XY Scatter Chart with X-axis displays the Category Name

[Max]

Hi, i am having data like this

Code - Qty
X - 100
Y - 500
Z - 700, i would like to plot xy scatter graph like in which,
X axis shows, all code name i.e X,Y,Z and Y axis shows the values, is it
possible ?

 

[Jon Peltier]

You've described a line chart. Line charts can use arbitrary labels as X
values, while an XY chart requires numeric values. In either type of chart,
the series formatting can be the same (e.g., XY charts with lines connecting
the points and Line charts with no lines). In this respect, the terminology
is confusing.

- Jon

 

[Max]

Thanx your post works.

You've described a line chart. Line charts can use arbitrary labels as X
values, while an XY chart requires numeric values. In either type of chart,
the series formatting can be the same (e.g., XY charts with lines connecting
the points and Line charts with no lines). In this respect, the terminology
is confusing.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______