| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autolabel Axis
I use Excel from Office 2004 on a Mac to analyse and present scientific data.
I draw a lot of graphs of spectra each day and the labels on the graphs are invariably one of 3 things. Is there any way that I can have a drop down list or something similar to select the axis labels instead of typing them each time, or can I set the writing above the column to read as x and y label rather than title and legend. Any help will be greatly appreciated |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autolabel Axis
You could create a macro of three options and run the macro you need.
"Fiona Dickinson" <Fiona wrote in message ... I use Excel from Office 2004 on a Mac to analyse and present scientific data. I draw a lot of graphs of spectra each day and the labels on the graphs are invariably one of 3 things. Is there any way that I can have a drop down list or something similar to select the axis labels instead of typing them each time, or can I set the writing above the column to read as x and y label rather than title and legend. Any help will be greatly appreciated |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| how to add a second x axis with same Y axis value in one plot | Charts and Charting in Excel | |||
| Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel | |||
| Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
| can't change how data on 2nd axis is being displayed | Charts and Charting in Excel | |||
Linear Mode
