+ Reply to Thread
Results 1 to 3 of 3

Bar chart secondary axis

  1. #1
    Registered User
    Join Date
    04-28-2011
    Location
    Maidenhead
    MS-Off Ver
    Excel 2007
    Posts
    2

    Bar chart secondary axis

    hi you clever monkeys...

    am not feeling it today so thought I'd widen the sphere of participation..

    Attached is a chart...3 legends on the x axis (2 bars each). data series on 1 of the legends is markedly higher than the other 2 and has therefore compressed the data in the lower value legends to practical invisibility.
    Can someone show me some love by providing me pls...would like the smaller legends scaled on a secondary access on the right in the same format as the one on the left...have looked at MS Help and the manual but no details or just too confusing OR am feeling right blonde today...
    If further description is required pls dont hesitate to contact me for assistance...
    I thank you from the bottom of my heart
    Rgds
    Mike
    Attached Files Attached Files

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Bar chart secondary axis

    Is this what you wanted? It requires a data rearrangement and some dummy series.
    Attached Files Attached Files
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    04-28-2011
    Location
    Maidenhead
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Bar chart secondary axis

    Perfect...thx very much RS....that was a truely mesmerizing performance from Russell Crowe BTW...look what's happened to him now??? The odd flash of genius marred by too many average and worse choices!!!
    Thx again...
    Putch!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1