Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Feb 2005
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Overlapping charts (Excel 2003)

    Dear Lounger,

    I have about 100 workbooks that contain a single sheet (attached sample). Each sheet contains different rows of data. Is there a way to automate the plotting of charts, a PDF example is also attached. (Or rather, is it even possible to plot that kind of chart in Excel?)

    Thank you All in advance.
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Overlapping charts (Excel 2003)

    I don't think Excel can do this with 3D charts, but it can be done with bar charts, using both a secondary category axis and a secondary value axis, and reversing the order of the secondary axes. See attached example.
    Attached Files Attached Files

  3. #3
    Star Lounger
    Join Date
    Feb 2005
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Overlapping charts (Excel 2003)

    Thanks Hans,

    Is it possible to automate the plotting though? I am still using the codes you provided a while back to open each workbook and plot line charts. I am stumbled on plotting this kind of bar charts now.

    Regards
    Riduwan

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Overlapping charts (Excel 2003)

    If you put all the workbooks in the same folder (without other workbooks), you can use the attached workbook. This workbook should be stored in another folder.

    Click the button to run the macro.
    Attached Files Attached Files

Posting Permissions

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