Bar Graphs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to plot values vs. numbers but the numbers don't increase in a linear or predictable patern so excel is filling in the numbers inbetween automatically. For example I want to plot values vs. 1, 2, 3, 4, 6, 8. 9, 11 and 15 and so on but instead of excel plotting my values vs. those numbers it plots them vs. 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14 and 15

How do I solve my dilema?
 
Z -

The X values in several types of charts (Line, Column, Area, Bar) are
treated by Excel as categories, not as numeric values. Even though there
is a gap between 6 and 8 in your example, Excel doesn't know to leave a
space where 7 is supposed to go. You could make a chart that leaves room
for missing values in two ways. First, make an XY Scatter chart, which
treats X values as numeric values. Or second, put in the missing X
values, and leave a blank cell for the missing Y values.

- Jon
 
Thanks for your suggestion. It's unfortunate that there isn't a better solution but I guess I have to work within the limitations of excel.
 
Back
Top