+ Reply to Thread
Results 1 to 2 of 2

Can excel create 4 Y-axis graphs?

  1. #1
    Registered User
    Join Date
    03-31-2006
    Posts
    1

    Can excel create 4 Y-axis graphs?

    like http://www.bunnytimes.com/saveit.JPG
    if so, how?
    if not, what app could do it?

  2. #2
    Forum Contributor
    Join Date
    08-08-2005
    Location
    Kansas, USA
    MS-Off Ver
    2016
    Posts
    293
    You could probably fake it with VBA, but I'm not well versed enough to tell you how.

    Excel does support a second X & Y axis. You can achieve the same effect by factoring the values to be plotted. For instance parameter A goes from 0-6, B from 0-1200, C from 0-5, D from 0-100. Insert helper column E to multiply A by 200 and helper col F to multiply C by 20. Set the primary Y axis as 0-1200, and plot E & B against it, with the label for E as "A*20." Likewise set the secondary Y axis scale 0-100, and plot F & D with F labeled as "C*20."

    Not as elegant, but it gets the job done.

    If you create on a worksheet (not in a separate chart page) dummy charts with the Y axis scaling you want, you could line these up, "parking" successive charts on top these with the chart above on top. This would then provide the appearance of what you want. Then you wouldn't have to do the funny labelling, although you would still need to plot the helper columns as noted above sine the actual plotting is done on the singel chart.

    HTH

    ---GJC

+ 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