View Single Post
 
Old 10-22-2015, 12:23 AM
Officer_Bierschnitt Officer_Bierschnitt is offline Windows 7 64bit Office 2013
Advanced Beginner
 
Join Date: Oct 2015
Posts: 87
Officer_Bierschnitt is on a distinguished road
Default Chart with both y-axes used - include more?

Hi,

I have a chart (column chart) displaying two figures which have to be on two different axes due to different magnitudes.
Now the people I did this for asked me to include the total sum per year of both figures - which of course is another magnitude again.
Logically, I cannot include this in the chart - I could, but since the axis always adapts to the largest value, all the other columns would become quite tiny.
Is there maybe a possibility to include one value which isn't taken into account by the axis, with the value displayed in or on the column?

Thanks a lot!
Best regards,

Officer_Bierschnitt
Reply With Quote