office 2007 help

Discussion in 'OT Technology' started by Teh | B-Unit, Jul 13, 2009.

  1. Teh | B-Unit

    Teh | B-Unit New Member

    Joined:
    Jul 14, 2007
    Messages:
    646
    Likes Received:
    0
    So my company decided to upgrade my office package from 03 to 07. I can't find any options for excel. I'm trying to insert a chart based on a specific data series displaying totals for certain categories. When i graph these optiosn the horizontal axis displays 1 and 2. However i only want to display the categories in 1 and remove the two so that the graph will only display one across the hole graph. In 03 i used the options to uncheck the horizontal category and make it a time scale. I cannot do this in 07. Any advice?
     
  2. Fase

    Fase Your Face, In A Pickle Jar.

    Joined:
    Apr 6, 2004
    Messages:
    29,540
    Likes Received:
    0
    Location:
    Windsor, Ont, Canada.
    You'll have to explain a little more.

    You have a y axis with the values 1 and 2. However, you only want to display 'categories' (or do you mean series?) that have the value 1? All you'd have to do is delete any data or remove it from the graph where it is > 1.

    I don't think this is what you want, but what are your x and y axis data in? Time, date, number, etc?
     

Share This Page