Remove null value categories from graph

Discussion in 'Microsoft Excel Charting' started by Raiju, Feb 24, 2009.

  1. Raiju

    Raiju Guest

    Hi,

    I am preparing a dashborad on a daily basis by putting the sales data. X
    axis will be the date and Y axis will have the sales value for the particular
    date. some of the dates there won't be any sales,ie. zero value.while drawing
    graph i will select the entire range, so all the dates will be appearing on X
    axis even if the value null. could anyone help me on this to remove the zero
    value dates from the X-axis ?
     
    Raiju, Feb 24, 2009
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    Simple x/y Graph, no categories

    Guest, May 4, 2004, in forum: Microsoft Excel Charting
    Replies:
    1
    Views:
    184
    Jon Peltier
    May 4, 2004
  2. LLC

    Half Bar Graph / Half Stack Graph ??

    LLC, Jul 8, 2004, in forum: Microsoft Excel Charting
    Replies:
    2
    Views:
    1,166
  3. Guest
    Replies:
    1
    Views:
    2,167
    Tushar Mehta
    Jan 3, 2006
  4. Guest

    Value displayed on graph is wrong- but graph is right?

    Guest, Jan 18, 2006, in forum: Microsoft Excel Charting
    Replies:
    0
    Views:
    188
    Guest
    Jan 18, 2006
  5. -markc
    Replies:
    2
    Views:
    689
    -markc
    Oct 31, 2007
Loading...

Share This Page