Column Graph

[redan]

Hello,

I have a column chart on which I would like to maximize the width of the columns. How do I do that ?

Thanks for the help!

PS : i have attached an example of what I mean...

[Andy Pope]

I think a series on the secondary axis may solve this one, hard to tell from just pictures.

[redan]

thanks Andy,

what if my data changes then the secondary axis will have to be modified again or is there a way to make this automatic...

cheers!

[Andy Pope]

Not sure I understand.
The chart will currently up date automatically if any of the data changes.

The only this you need to change manually is the addition of categories,

[redan]

Hello Andy,

Once you add a new categories and then plot series on the secondary axis. The scale of the new axis different from the second. How did u manage to make identical ? Did u do it manually by setting the maximum or else ?

Thanks for your help!

[Andy Pope]

Once you have the series placed on the secondary axis select and delete it.
This will allow the series to still be on the secondary axis but will take it's min/max values from the primary.