Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Sep 2003
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Change scale of a graph (2000)

    Hello All,

    Attached is a file that contains a chart that I am trying to adjust. The quarterly data only goes as high as lets say 200, then on the same chart i display the annual total for the 4 quarters. however, the jump that the bars make is too drastic. i need a way to adjust the scale of the graph, to get rid of the dead space aove the Quarterly data. i tried the scale using LOG and it is too much of a jump from 100 to 1000. if i could eliminate graphing from 250-500 lets say i think id be good. i would like my scale to have its y axis lok like this , 0 200, 500, 800. Any ideas on how to set this up? thanks a lot guys.

  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: Change scale of a graph (2000)

    Check out one of Jon Peltier's chart tricks for making a "broken" y-axis.

    Steve

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

    Re: Change scale of a graph (2000)

    Steve,

    Apparently, you caused a stampede. The site has exceeded its bandwidth allocation <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  4. #4
    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: Change scale of a graph (2000)

    I am just doing my fair share <img src=/S/meltdown.gif border=0 alt=meltdown width=15 height=15>

    Steve

  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: Change scale of a graph (2000)

    Did you use the addin suggested?

    It sounds like you just put in the value (0) for all of them. You must put the LABELS you want. You can do it manually by selecting each datalabel and editing it, by Rob's addin makes it so much easier to add labels that are NOT the x or y-values.

    Steve

  6. #6
    New Lounger
    Join Date
    Sep 2003
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Change scale of a graph (2000)

    (Edited by HansV to activate URL - see <!help=19>Help 19<!/help>)

    ok this is exactly what i need BUT i cant seem to get any values for my marker values. the step that says

    "Double click on the Markers series, click on the Patterns tab, and change the markers to a black cross, size 6. Using Rob Bovey's Chart Labeler (a free addin from http://www.appspro.com), I added the labels in H2:H13 to the Markers series along the Y axis. I selected the Left position option; they didn't come out quite right, but 'll fix that in a minute.

    How do i add the labels from my H2:H13 to the markers series along the y axis? someone pleas ehelp all in get is "0"' for each value. If i could set those to my H column i'd be set, thanks alot.

  7. #7
    New Lounger
    Join Date
    Sep 2003
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Change scale of a graph (2000)

    i installed the excel utilities addin and thats all i did, did i miss a step? thx

  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: Change scale of a graph (2000)

    Tools - xy chart labels - add chart labels
    Choose the data series
    Choose the range of the values you want as labels
    choose left
    <ok>

    Steve

Posting Permissions

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