Results 1 to 3 of 3
  1. #1
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    custom dual-axis chart (Excel2000)

    How can I make a custom y scale for a dual y-axis chart (customize the secondary axis)? Attached is a sample of the chart I need (from a PowerPoint presentation) and the actual chart and data. I turned off auto-scale for the secondary y-axis and entered the min/max values but it's still not exactly what I want. I don't know how the PPT chart was done and that's what I'm after. Can it only be done in VBA? <img src=/S/clever.gif border=0 alt=clever width=15 height=15>

    Thnx, Deb

  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

    Re: custom dual-axis chart (Excel2000)

    How is this chart?
    You didn't give a relationship for GM to CBR Disc so I calc's it based on 5 points (connecting lines)
    I used an XY CHart
    I drew the GM (Blue Line)
    I calc'd (from the 5 points that you list as the same) the "GM value" from the CBR Disc) and plot this line (Red Line)

    The "Grid lines" are a separate range with XY coords

    I created 3 ranges for "axis labels" (Left labels, right labels, Bottom labels)

    The axis titles are text boxes and the labels on the chart are text boxes and I added some arrows. These could be "drawn" and placed on the chart with coords if you need a more "generic" and "living placement"

    Is this what you are after? It is not completely generic, but I didn't know what you all needed
    Steve

  3. #3
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: custom dual-axis chart (Excel2000)

    WOW this is great <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23> I never would of figured this one out. I've never used the scatter chart and wasn't aware of some of the fields you used. My co-worker will be thrilled. I'm definitely keeping this one for future reference.

    Thank you so much, <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>
    Deb

Posting Permissions

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