Using Currency and percentage in a single graph

[kdsouza77]

I want to use currency and percentage in a single graph is it possible.

For example: I want to show the growth in revenue and the percentage of cost that is incurred to achieve it.

Revenues are always 6 digits.

 

[vasim]

Welcome to the forum (on Hui's reminder)......


Use secondary axis...this is how it should work for you...


Prepare column graph as usual, now since your %age are very low it wont be visible, so for timebeing increase any 1 of your %age manually to the extent that its visible. Click on the %age column, right click select Chart type change to Line graph, next doubl click on line graph - go to axis tab and select secondary axis...


That should be it, change the manully entered cell to the previous formula.


P.S: The %age parameters will now be shown on right side, so do remember to mention in the graphs to avoid confusion.

 

[Hui]

Yes its possible

Add the two series to a chart and put one on the primary Axis and the other on the secondary axis

Right click either series and Format Series, select Primary or Secondary Axis

 

[kdsouza77]

Thanks a lot Indian and Hui, I am able to achieve what I desired.