Chart with both y-axes used - include more?

[Officer_Bierschnitt]

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

[Pecoflyer]

Perhaps like this http://peltiertech.com/Excel/Charts/TertiaryAxis.html

Be aware that three axes will make things confusing.

Perhaps the described Chart Panel approach would be better

[Officer_Bierschnitt]

You are right.

A tertiary axis certainly would make the chart quite confusing. I know about panel_charts, I have created some in QlikView, using different scales - I do think it's easier and less confusing than using two axes - especially because in Excel, most people who use a secondary axis don't include any hint on which measure to "read" on the left-hand one and which on the right-hand one ...
A chart with a horizontal split would be even better - I'd have the x-axis for the months from Jan to Dec and beside that, a second x-axis with just one datapoint which would read "Total".

I am just wary of offering people tools they are not used to, even if they are in fact better ... that can be tricky. I'll try it out, though, if only for myself.

I think

[Officer_Bierschnitt]

Hi,

I think that chart_panel_approach would be a possibility, but probably quite time-consuming as I'm not very fluent in Pivot_tables anymore.

I think for the time being I'll rather go with a separate chart and, as the dimension of this has only one datapoint, I'll try to make it as thin as possible.

That is where another question comes up: Can I somehow move the labels of the y-axis? The thing is, there is quite some white space around those two columns, but inside the charting_area. The axis labels, however, which all have three 0s, are to the left of the axis and as I make the chart thinner, that gets all but illegible.
=> Can I somehow make this go across the axis and into the charting_area?

Thanks a lot!

Best regards,

Officer_Bierschnitt

P.S.: Well, I tweaked it a bit now and it looks quite ok, with the axes altogether gone, just an axis_title beneath (there is only one point on the dimension anyway) and the data_labels on top of the columns.
I guess that's that for this issue.

[Officer_Bierschnitt]

Well, I found a way now - not quite as nice as a panel_chart such as described on that WebSite, but well, I could do that without first spending a lot of time getting cozy with Excel again.
I simply used the additional chart, stripped it of axes and legend, leaving only an x-axis_title and data_labels and then made it as thin as possible.
I guess that is that on this issue. I'll try out something else.

Best regards,

Officer_Bierschnitt

[Officer_Bierschnitt]

Hi,

that tech_blog is a bit hard to follow - the examples seem to have been done with an earlier version of Excel - I have Excel 2013 and it all looks a bit different.
I'm just trying to implement this panel_chart with panels on top of each other.
Let's see ...