Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Green Bay, Wisconsin, USA
    Posts
    396
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Excel 2010 bar chart with 2 y-axis

    We have created a chart using 2 y-axis with a bar chart and line chart. Now they want both to be bar charts, but the bars next to each other.

    I remember doing this with off set, but in Excel 2010 I cannot find the feature. Can anyone help?

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Normally you would plot a dummy blank series on each axis and adjust the series order so that you plot say:
    Axis 1: dummy series then real data
    Axis 2: real data then dummy series

    see attached demo.
    Attached Files Attached Files
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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