ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   changing x axis of column graphs (https://www.excelbanter.com/excel-worksheet-functions/104241-changing-x-axis-column-graphs.html)

Blah

changing x axis of column graphs
 
I want to change the numbers on the x axis of my 'column' graph with a
list of
values I have. Anyway I would be able to pull this off?


Ken Johnson

changing x axis of column graphs
 
Hi Blah,

Select the column chart.
Go Chart|Source Data...|Select the "Series" tab|Click on the little
button on the right side of the "Category (X) axis labels:" box|Select
the range of cells containing the new x axis labels|Click on the little
button again to return to the "Data Series" dialog|OK.

Ken Johnson



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

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