| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 ? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 ? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Scatter chart displays as line chart | Charts and Charting in Excel | |||
| stock chart category axis | Charts and Charting in Excel | |||
| Category axis in bubble chart | Charts and Charting in Excel | |||
| How do I make the Y axis in an excel chart the category axis? | Charts and Charting in Excel | |||
| Bar chart & Category (x) axis labels | Charts and Charting in Excel | |||
Linear Mode
