Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Sep 2011
    Posts
    7
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Adding a line to a stacked bar chart

    Hi,

    I currently produce a stacked bar chart that shows the percentages of people improving and getting worse for individual organinsations dependent upon the orgainsation selected from a drop-down list.

    I have been asked to look at adding the overall percenatges to this chart, e.g. for a given organisation and measure, the improvement percentage may be 40%, but the national improvement percentage is 45%.

    Ideally I just wanted to add the national percentages as data point on a line graph before removing the line leaving only the reference points. However, upon adding the data it is plotted on a secondary axis reading across the page rather than down.

    Any suggestions as to how I can 'turn/rotate' the line graph are appreciated.

    Robin

  2. #2
    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
    See Jon Peltier's description at http://peltiertech.com/Excel/Charts/BarLineCombo.html

    Steve

  3. The Following User Says Thank You to sdckapr For This Useful Post:

    RobinHackshall (2011-09-13)

  4. #3
    New Lounger
    Join Date
    Sep 2011
    Posts
    7
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Steve,

    Thanks for the link. I have been able to update my chart as required.

    Robin

Posting Permissions

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