Graphs 1

[diannelight]

Hi,
Please could you tell me
1. if it is possible to change the names of the legends?
2. is it possible to customise the colours of column data in the graphs?
Thank you.

 

[pgtek]

hi

Yes to all
you can if you used the format the chart expert
as for changing the legend use a formula instead of the field name

hope this helps

cheers

pgtek

 

[diannelight]

Excuse my ignorance, but I can't find any options to change the colours (I'm using version 8.5).
As for the legends, even if I do create a formula, it still reads:
'sum of' {fieldname}. Any other suggestions?

 

[lbass]

To change the color of the bars, select the chart, right click and choose "chart analyzer." Then select the bar, right click, and choose format chart->selected item->fill tab.

For the legend, if I'm remembering right, the only way I could change a legend was by

 

[lbass]

Oops, clicked the wrong button. As I was saying, the only way I've found in 8.0 to change the legend is to overlay a text box with the desired text and then format the text box background color to be white, so the actual legend text is not visible. I always increase the magnification so that it's easy to see exactly how to size the text box.

-LB

 

[diannelight]

LB, I'm sorry - neither of these worked for me.
I don't have an option for 'chart analyzer' and a right click on the chart, 'format chart', 'selected item' (option is not always there), only allows me to change the background colours not the indivdual bars.
Also tried using a text box (with magnification) to replace legend text but can't align to legend colours. I'm not too worried about that but I would like to change the bar colours - any other ideas?

 

[lbass]

I have 8.0--don't know your version--but to get to the chart analyzer, select the chart, right click on it in preview and you will see "Chart Analyzer." Click on that and you will see the chart on its own screen. Click on a bar, so that it is selected (not that the whole chart, which would change the background color), and then right click and choose "format chart" and then "selected item" and "fill."

As far as the legend goes, I think if you magnify enough you should be resize the text box accurately to align with the colors.

-LB

 

[ChainsawJoe]

There's a "better" solution for colouring bar charts:

http://support.crystaldecisions.com/library/kbase/articles/c2010466.asp

"To format the bar chart so that all the bars are the same color, complete the following steps:

1. From the 'Insert' menu, select 'Field Object'. This launches the 'Field Explorer'.

2. Select 'Formula Fields', select the 'New' icon.

3. Type a name into the 'Formula Name' box, and click 'OK'. For example, FormatChart. This launches the formula editor.

4. Create a formula similar to the following:

//this formula will return a zero value
WhileReadingRecords; 0

5. Save and close the formula.

To insert the @FormatChart formula into the chart, complete the following steps:

1. Right-click the chart and from the fly-out menu, select 'Chart Expert'.

2. From the 'Type' tab, select 'Stacked Bar Chart.

3. From the 'Data' tab, add @FormatChart to the 'Show Value' box.

4. Select @FormatChart and move it to the top of the order. In other words, drag and drop the formula in the 'Show Value' box to be first in the list.

5. Click 'OK'.

Now, when you refresh the report the bars are all the same color. "



--------------------------------------------------

http://www.chainsawjoe.com

- better than toast.
Penguins - better than

http://www.chainsawjoe.com

--------------------------------------------------

 

[diannelight]

ChainsawJoe,
Thank you so much - the stacked graph works for me.
1. Do you have any idea as to how I could show the legend on a graph to not include the '@' of the formula - can I create my own legend text?
2. Also, can I format the numbers on my graph to display only whole numbers not eg. '1.6' etc.?
Thanks again.