Bar Graphs

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Zantetskuen wrote:

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?

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.