| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Format chart axis by inputting data in a cell
I'd like to format the chart axis by linking the Maximum and Minimum scale to
2 cells in another worksheet. This way I can protect the sheet with the chart and the user can still change the axis. Any help would be appreciated. Thanks. |
|
#2
|
|||
|
|||
|
I think you will have to write a macro to do that.
"Mike" wrote: I'd like to format the chart axis by linking the Maximum and Minimum scale to 2 cells in another worksheet. This way I can protect the sheet with the chart and the user can still change the axis. Any help would be appreciated. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stacked Bar Chart with Secondary Axis | Charts and Charting in Excel | |||
| "Broken" chart axis for data of different scales | Charts and Charting in Excel | |||
| Formatting dates on x axis of chart...! | Excel Discussion (Misc queries) | |||
| changing proportion of chart and data table | Charts and Charting in Excel | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Linear Mode
