ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   text data on X axis (https://www.excelbanter.com/charts-charting-excel/121496-text-data-x-axis.html)

ajent

text data on X axis
 
Is it possible? My Y data are numbers but I would like to put the X
coordinates as text, eg.: (a;12), (b;9), (w;2;8) etc., the chart of XY type.
I can't find anything like that in Help. Thank you.



Jon Peltier

text data on X axis
 
Create a Line chart. The chart will treat each text item as its own category
label. If you have any duplicate labels, you will end up with duplicates
along the chart axis.

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


"ajent" wrote in message
...
Is it possible? My Y data are numbers but I would like to put the X
coordinates as text, eg.: (a;12), (b;9), (w;2;8) etc., the chart of XY
type. I can't find anything like that in Help. Thank you.





All times are GMT +1. The time now is 03:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com