ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I set up column charts' x values in 'm' ie. 300m, 600m etc (https://www.excelbanter.com/charts-charting-excel/41573-how-do-i-set-up-column-charts-x-values-m-ie-300m-600m-etc.html)

t4gbg

How do I set up column charts' x values in 'm' ie. 300m, 600m etc
 
I am learning charting in Excel. How do I display x values axis as 300m,
600m, 900m while the values displayed inside the columns are 256.4, 488.7 and
822.3

Bernard Liengme

You make an XY chart not a Line chart. Line charts are used when the
x-values are categories (text or numbers that are not used numerically like
serial numbers)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"t4gbg" wrote in message
...
I am learning charting in Excel. How do I display x values axis as 300m,
600m, 900m while the values displayed inside the columns are 256.4, 488.7
and
822.3





All times are GMT +1. The time now is 11:03 AM.

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