Highlighting Secondary axis values in Line Chart

[ondrejm]

Hi,

I have the following problem. I have one set of data (revenue values for countries by months). Given how the individual countries perform, I have the high performing countries on the X axis and the low performing countries on the Y axis so that it is possible to see the evolution of the revenue over time. My problem now is that it is not clearly visible which series is shown on which axis, meaning that the chart may look a bit misleading as small revenue countries may look better than some of the high performing ones.

I know I could (partially) solve this by making the x axis logarithmic or by making the max value of the y axis smaller to ensure that the values are not higher on the chart but I would like to know if it is possible to distinguish / highlight which series is shown on which axis (using either gridlines or by splitting the label somehow or anything else).

Thanks in advance.

 

[Steve=True]

Hi ondrejm,

I would consider setting up your data in a panel chart look.

Check out this link:

how-to-make-a-wall-street-journal-horizontal-panel-chart-in-excel

Instead of columns, you can use line charts.

Instead of 3 panels, you can use 2 panels with high performers on one and low performers on the other.

Please let me know if it helps.

Steve=True