XY Scatter Chart with X-axis displays the Category Name
 

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 ?

XY Scatter Chart with X-axis displays the Category Name
 

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
_______


"Max" wrote in message
...
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 ?

XY Scatter Chart with X-axis displays the Category Name
 

Thanx :-) your post works.

"Jon Peltier" wrote:

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
_______


"Max" wrote in message
...
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 ?