We have primary and secondary Y axes, but only the primary X axis. Right click the Secondary series, choose Format Series (or similar, it varies with Excel version), and select the Secondary Axis option. Start your panel chart by making a line chart with the data. You can avoid the problems with two-axis charts by plotting the data in separate panels. Through intentional or inadvertent axis scale dishonesty, you can tell any story you want. In contrast, the data in this chart starts the same, but after several months the two series suddenly diverge.īut it’s the same data in both of the previous charts. By the end of the year, they have switched places. Here the series start out far apart, one much higher than the other for several months. It is hard to separate the data, despite the presence of the two axes. Who can figure out, let alone remember, which data should be measured against which axis? Our eyes see the series overlapping, and our brain interprets them as having overlapping data ranges. When we move the Secondary series to the secondary axis, there is an apparent relationship between the series, which changes as the axis scales are changed. Problems with Primary and Secondary Axis Line Charts Values for the two data series fall within vastly different ranges, as seen in this line chart. Let’s use the following simple data for this exercise. This article shows the instructions for a two-panel line chart. Easy Two-Panel Column Chart in Excel was the first of several quick tutorials on easy panel charts. I’ve written often about panel charts, and I’ve made some simple ones, but I don’t seem to have explained the process in enough detail for people to reproduce these simple ones with their own data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |