Results 1 to 7 of 7

How to get Excel chart to ignore zero values, widen columns, and move axis

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-22-2010
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2003
    Posts
    152

    How to get Excel chart to ignore zero values, widen columns, and move axis

    Hi,

    I am using Excel 2010 in 2003 compatibility mode. I am trying to create a graph that shows movement of results up or down from a baseline of 90%. I'm having several problems with it:

    1- The columns are all squashed up as though it is leaving space for the other days of the week. I want them spread out across the gap as the data is shown at weekly intervals, not daily.

    2 - I want the axis to cross at 90% which is our target, however, this moves the axis category names into the middle of the graph. Can these be moved back down to the bottom of the chart?

    3 - I have selected for zero values to be shown as gaps, however, they are still appearing as zero making the chart unreadable.

    i have attached a stripped down version of my original sheet. Would appreciate any advice.

    Thanks,
    Attached Files Attached Files

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