Charts

[BigOCombe]

Hello Group,

I have two questions in regards to charts.

1) I have a combination chart with 2 Y axis and use the default color when the chart is created. The first axis is a bar and the second a line. I change the color of the line and run the report with expected results. When I run it in Excel it defaults back to the default color and not the color that I had changed it to. Is there a way to correct this?

2) I have a report with multiple charts. I have combination and simple bar charts. The combination charts spread nicely accross the width of the page, but the bar chart his half of the width of the combination chart. I have looked for ways to change the width of the bar chart but could not find any. Any suggestions on how to get both charts to be identical in size?

Thanks!

[BigChris]

On the second point, have you taken into account the legend(s)? They count as part of the width of the graph. You can specify the width in the size and overflow box, then put the legend below the graph to make the width of the "picture" element to be the same.