Results 1 to 4 of 4

Thread: Graphs (1)

  1. #1
    Star Lounger
    Join Date
    Jan 2002
    Location
    London, Gtr London, England
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Graphs (1)

    Okay, this may not be possible, either to explain or do, but this is my ideal world.
    Refer to attached spreadsheet. I want to Graph Total Outstanding Work, but not have an axis mark at every data point, just plotting the four data points within one axis group of April, the five for May and so on. As other graphs need to be smaller than this one.

    Please help as I have troubles doing these formatting tasks.

    Thanks Cindy
    <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>
    Attached Files Attached Files

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts

    Re: Graphs (1)

    Right-click on the x-axis
    From the Formatting dialog box select tab sheet 'Format Axis'
    For the top left corner where it shows 'Lines' change radio button option from 'Automatic' to 'None'

    zeddy

  3. #3
    Star Lounger
    Join Date
    Jan 2002
    Location
    London, Gtr London, England
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Graphs (1)

    Zeedy,

    I do not want the axis lines to disappear totally I want them to appear in groups. If you refer to my attached spreadsheet, I would like April to comprise of the four points, but just have one mark with April, then May comprise of the following five points, have another end mark and May in the middle of the two marks.

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

    Re: Graphs (1)

    Hello Cindy,

    I fear that it's not possible.
    The distance between the tickmarks on the axis is constant - you can have one tickmark for every category, or for every three categories etc., but not an irregular distribution: 4, then 5 etc. VBA has a property TickMarkSpacing that applies to the whole axis, not to parts of it.

    I'm curious whether one of the Excel wizards on this forum can come up with a brilliant trick, but I suspect that it would not be easy.

Posting Permissions

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