PC Review


Reply
Thread Tools Rate Thread

changing Chart Legend text .for cr.NET?

 
 
Rob
Guest
Posts: n/a
 
      14th Jul 2004
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.
 
Reply With Quote
 
 
 
 
=?Utf-8?B?QnJpYW5ESA==?=
Guest
Posts: n/a
 
      14th Jul 2004
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.
>

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
chart legend changing when I use Select data Steve Cawood Microsoft Excel Charting 1 1st Dec 2009 05:46 PM
change the text in the legend of a chart w/o changing pivot text msp Microsoft Excel Charting 2 17th Dec 2008 08:53 PM
Changing the order of a chart legend =?Utf-8?B?VGltIFdoZWVsZXI=?= Microsoft Excel Discussion 0 7th Nov 2007 03:52 PM
Chart Legend: Include more Data in my chart legend than what I have graphed eliese0 Microsoft Excel Charting 2 9th Aug 2004 11:30 PM
Changing titles in legend of chart =?Utf-8?B?TmVlZCBIZWxw?= Microsoft Excel Charting 1 17th Feb 2004 10:31 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:14 PM.