473,480 Members | 3,796 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

changing Chart Legend text .for cr.NET?

Rob
Hello;
I searched and could not find a solution.
DOes anyone know how you can actually have the Chart Legend reflect
your report/table?
I am using a simple two column table like this to test out graphing
abilities of the cr graphs
year sale
1993 50
1994 50
1995 75
1996 67
1998 95

On the Data tab on the chart expert it will not let me say to show
values for both columns, it simply grayes out year field, and
therefore when the graph comes up, all you see in the legend and on
the pie chart itself is just an autonumber starting at 0, but it does
show the sale #'s?

any ideas?
thanks in advance.
Nov 20 '05 #1
1 2411
rob

After you drop your chart into your CR select Type example (Line) then Data
Under Data Select Layout (Advanced)
Select from the ListBox (Available fields) the fields you wish to have in your chart.
Move Year and or Sales into the top box on the right and Sales into the (Show Values) box bottom right or a formula.
Then goto the Axes Tab: Grid Lines Data Axis Major
Data Values Auto range
Number Div auto
hope this helps.
B
"Rob" wrote:
Hello;
I searched and could not find a solution.
DOes anyone know how you can actually have the Chart Legend reflect
your report/table?
I am using a simple two column table like this to test out graphing
abilities of the cr graphs
year sale
1993 50
1994 50
1995 75
1996 67
1998 95

On the Data tab on the chart expert it will not let me say to show
values for both columns, it simply grayes out year field, and
therefore when the graph comes up, all you see in the legend and on
the pie chart itself is just an autonumber starting at 0, but it does
show the sale #'s?

any ideas?
thanks in advance.

Nov 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1495
by: wangyang | last post by:
I designed a crystal report by Microsoft Visual Studio .NET (Version 1.1),and I inserted a chart in the report. All Text Font are "Arial" in the chart. I viewed the report in web application and...
0
1749
by: DAL | last post by:
I have created a Pivot Chart that Graphs our orders per month and what type of order they are, either Custom or Standard. To get the data we use an input Form the uses a Combo Box to choose either...
2
3106
by: Dave | last post by:
I'm trying to follow the examples in VBAGRP9.CHM and/or VBAGR10.CHM with no success. I'm trying to Chage the Legend Colors based on Content so that I can establish a certain color format on...
6
5656
by: ghanley | last post by:
Does anyone know how to change the datasource of an Embedded Excel chart in an unbound Object Frame. How to reference the properties?? I want to do something like this. Dim XLChart as...
9
3057
by: Patrick.O.Ige | last post by:
I have a code below and its a PIE & BAR CHART. The values now are all static but I want to be able to pull the values from a database. Can you guys give me some ideas to do this? Thanks ...
1
1872
by: rkbnair | last post by:
I created a pie chart in an aspx. However, how can I display the data in the piechart itself in the right location? The code is as follows: (Please see the definition of float x and float y) ...
0
2352
by: Bon | last post by:
Hello guys Could anyone give me some hints on writng vba code for deleting legend with zero value. My chart is just shown percents There is a legend shown on the right hand size. I used the...
1
2506
by: mike11d11 | last post by:
I was wondering if it was possible to export information from a pivot chart when double clicking on the item I want. For example I have a pivot chart with Four items in the legend and they are...
0
2501
by: madhatter84gn | last post by:
I am trying to automate an excel spreadsheet and then create a chart. Dim chartRange As Excel.Range If rollup Then chartRange = sheet.Range("O2:Q14", Type.Missing) ...
0
7040
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
6905
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7080
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
5331
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
4772
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4478
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
2994
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
1
561
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
178
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.