ExcelBanter

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

lpeterson

X axis
 
how do i change the verbiage of the "category X axis"?
it's showing 1,2,3 etc, i want it to show months. i have selected the
months in the source data and not selected them.
be gentle w/me...don't understand many of the terms used in a graph.

Andy Pope

X axis
 
Hi,

Select the chart and right click. Pick Source data.
On the Source data dialog go to the Series tab. At the bottom is a text box
that will allow you to select the range to use as Category labels.

You may find Jon's pages helpful.
http://peltiertech.com/Excel/ChartsHowTo/index.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"lpeterson" wrote in message
...
how do i change the verbiage of the "category X axis"?
it's showing 1,2,3 etc, i want it to show months. i have selected the
months in the source data and not selected them.
be gentle w/me...don't understand many of the terms used in a graph.




All times are GMT +1. The time now is 11:54 PM.

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