ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   In a bar chart, how do I change the x-axis "category" labels? (https://www.excelbanter.com/excel-discussion-misc-queries/58332-bar-chart-how-do-i-change-x-axis-category-labels.html)

thermactor

In a bar chart, how do I change the x-axis "category" labels?
 
I am trying to make a bar chart with customized category labels along the x
axis for each bar. I'd like them to be a series of numbers (100, 125, 160,
200...) etc. I can't get anything but numbers 1, 2, 3, 4... to appear...

Thanks

Ken Johnson

In a bar chart, how do I change the x-axis "category" labels?
 
Hi Thermactor,
If your categories are in the column just to the left of graphed
quantities, and, if you select both columns before inserting the Bar
chart, the categories will appear on the vertical axis.
Ken Johnson



All times are GMT +1. The time now is 02:25 AM.

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