View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Max Max is offline
external usenet poster
 
Posts: 390
Default 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 ?