Results 1 to 2 of 2

Thread: Data Series on 2nd Axis Blocking Other Columns?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    May 2010
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Data Series on 2nd Axis Blocking Other Columns?

    I have a column chart with 3 data series. When I move the third data series to a 2nd axis it moves to the center of the other columns, blocking them?? I want the series tied to the 2nd axis to be the third column. TIA!

  2. #2
    MrExcel MVP
    Join Date
    May 2003
    Location
    USA
    Posts
    4,678
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Data Series on 2nd Axis Blocking Other Columns?

    Using secondary axes in charts seems like a great idea, at least until someone else has to read the data from the chart. I wrote about this in Secondary Axes in Excel Charts. Aside from the usual confusion, when you have a column chart with series on different axes, the secondary series obscure the primary series. You can play games with dummy series that have zero values, and pad each axis with enough of these dummy series to push the real data to one side or the other, but you will still have the problem of comprehending which data goes with which axis.
    Jon Peltier
    Peltier Technical Services, Inc.
    Try Peltier Tech Charts for Excel

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •