XY Scatter Chart with X-axis displays the Category Name

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

Guest

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 ?
 
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
 
Thanx :-) your post works.

Jon Peltier said:
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
_______
Click to expand...
 
Back
Top