Results 1 to 10 of 10
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sophisticated Charting (2003)

    Is there an add-on for Excel that enables the creation of more sophisticated charts? Or what other applications could be used for this purpose? Thanks, Andy.

  2. #2
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sophisticated Charting (2003)

    Hi Andrew

    I rarely use charts but I did find a nice free add in that added animated charts to Excel, when I go home this evening I will dig the link out if it is of any use to you

    Cheers

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

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

    Re: Sophisticated Charting (2003)

    You can do a lot with the built-in charts, see for example Andy Pope's Charting Examples and Jon Peltier's Excel Charts.

  4. #4
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sophisticated Charting (2003)

    Thank you very much, but it's not animation that is required. I need, for example, two y-axes with different scales with a slight gap between them, among other things. Andy.

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Sophisticated Charting (2003)

    2 y Axes are built in. Dbl-click one of the ranges and in the format dialog, choose series (tab) and selct secondary axis and it will plot on the right side. The 2 axes are independent and you can change the min/max for each separately

    Steve

  6. #6
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sophisticated Charting (2003)

    Thank you, but the requirement is to have two axes that appear on the left with a 'slight' gap to indicate that they represent two different series. For example, one axis line could be red and the other blue with two similarly coloured series lines. Andy.

  7. #7
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sophisticated Charting (2003)

    Thanks. These are interesting links that I will keep for future reference as well. Andy

  8. #8
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Sophisticated Charting (2003)

    You can adapt Peltier's Vertical Category Axis to include the secondary axis as more offset and include them both.

    Steve

  9. #9
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Sophisticated Charting (2003)

    Another simple way is just to create 2 charts and overlay them (see attached) after making the top one transparent.

    Steve
    Attached Files Attached Files

  10. #10
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sophisticated Charting (2003)

    Thank you to everyone involved. I now have a number of interesting resources/ approaches to extending Excel's charting capabilities. It's a shame that MS has not taken the opportunity to extend these capabilites with Excel 2007. 2007 charts look very nice but do not add to the available chart types. Andy

Posting Permissions

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