Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Bar-line combo chart

Latest post Mon, Jan 14 2008 7:23 PM by dermot. 1 replies.
  • Mon, Jan 14 2008 6:15 PM

    Bar-line combo chart

    I have found the following link (http://peltiertech.com/Excel/Charts/BarLineCombo.html) which has shown me how to create the chart I want, however I would like to increase the number of bars from 5 to 32 for my application. In doing so though I have noticed the alignment of the bars and lines becomes displaced when you go above 10 bars. Is there a way I can use this style chart with 32 bars? Thanks Ben
    Filed under:
    • Post Points: 21
  • Mon, Jan 14 2008 7:23 PM In reply to

    • dermot
    • Top 25 Contributor
    • Joined on Wed, Jan 9 2008
    • Perth
    • Posts 39
    • Points 985

    Ben, check the numbering on the axes and on your Y series. I've seen it done with over 30 series, so chances are you have a small error.

    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.