• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11. Advanced Chart Topics > Adding a Second Y-Axis

Adding a Second Y-Axis

Some charts require that some data be plotted against a secondary Y-axis. This typically happens when one or more series use radically different values than the other series. Sometimes you still need to plot all of the series together in order to look for correlations between the two sets of numbers, and a secondary Y-axis helps you do this. For example, consider the chart in Figure 11.2.

In the example in Figure 11.2, you really can't see much of the data! Three of the series (Purple, Yellow, and Green) are completely hidden against the zero value. But are they truly zero entries, or are they clustered down there simply because the values of Blue and Red are so large? To find out, you can move the Blue and Red series to a secondary Y-axis that plots their values independently of the other series. To do this for each series you want to move to a secondary Y-axis, follow these steps:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint