ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   X-Y axis names (https://www.excelbanter.com/excel-discussion-misc-queries/112017-x-y-axis-names.html)

Wally

X-Y axis names
 
My X-Y axis are showing 1,2,3.. How do I change Y axis to a,b,c..

David Biddulph

X-Y axis names
 
"Wally" wrote in message
...
My X-Y axis are showing 1,2,3.. How do I change Y axis to a,b,c..


Are you talking axes on a chart (in which case you may be better off at
microsoft.public.excel.charting), or do you mean row & column names? If you
mean that your column names have changed to numbers & you want to reset to
letters, you need Tools/ Options/ General, & unset R1C1 reference style.
--
David Biddulph




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

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