Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to determine chart name
I have multiple sheets and there is a single chart on each sheet. I
want to use this macro but not all charts are named Chart1. Is there a way the macro can be made to work no matter what the chart name is? Sub TestChart() With ActiveSheet.ChartObjects("Chart 1").Chart.Axes(xlValue) .MinimumScale = WorksheetFunction.Min(Range("B3:B17")) .MaximumScale = WorksheetFunction.Max(Range("B3:B17")) End With End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to determine chart name
Why don't you just select the chart on each sheet and rename it, give them
all the same name. -- __________________________________ HTH Bob "Fan924" wrote in message ... I have multiple sheets and there is a single chart on each sheet. I want to use this macro but not all charts are named Chart1. Is there a way the macro can be made to work no matter what the chart name is? Sub TestChart() With ActiveSheet.ChartObjects("Chart 1").Chart.Axes(xlValue) .MinimumScale = WorksheetFunction.Min(Range("B3:B17")) .MaximumScale = WorksheetFunction.Max(Range("B3:B17")) End With End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to determine chart name
On Sep 30, 12:52*am, "Bob Phillips" wrote:
Why don't you just select the chart on each sheet and rename it, give them all the same name. I did think of that. I hane no idea how to rename a chart. How is it done? Excel97 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to determine chart name
On Sep 30, 6:14*am, Fan924 wrote:
On Sep 30, 12:52*am, "Bob Phillips" wrote: Why don't you just select the chart on each sheet and rename it, give them all the same name. I did think of that. I hane no idea how to rename a chart. How is it done? Excel97 I found this and it tells me how to do it. Thanks Bob. http://support.microsoft.com/kb/169882 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to determine chart name
If you are *sure* each sheet only has one chart
With ActiveSheet.ChartObjects(1).Chart.Axes(xlValue) 'etc Otherwise go with Bob's suggestion (to manually change a chartobject's name: hold Ctrl+Shift, new name in the Names box left of input bar) Regards, Peter T "Fan924" wrote in message ... I have multiple sheets and there is a single chart on each sheet. I want to use this macro but not all charts are named Chart1. Is there a way the macro can be made to work no matter what the chart name is? Sub TestChart() With ActiveSheet.ChartObjects("Chart 1").Chart.Axes(xlValue) .MinimumScale = WorksheetFunction.Min(Range("B3:B17")) .MaximumScale = WorksheetFunction.Max(Range("B3:B17")) End With End Sub |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to determine chart name
You can also do it by holding down shift and then click the embedded chart
once. This has the advantage of the cursor changing to an arrow-headed cross, good visual feedback. -- __________________________________ HTH Bob "Fan924" wrote in message ... On Sep 30, 6:14 am, Fan924 wrote: On Sep 30, 12:52 am, "Bob Phillips" wrote: Why don't you just select the chart on each sheet and rename it, give them all the same name. I did think of that. I hane no idea how to rename a chart. How is it done? Excel97 I found this and it tells me how to do it. Thanks Bob. http://support.microsoft.com/kb/169882 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Determine if a chart exists | Excel Programming | |||
Using a formula to determine variable rows in Chart | Charts and Charting in Excel | |||
Determine if data label overlaps chart title? | Charts and Charting in Excel | |||
determine colouring of variables of a pie chart | Charts and Charting in Excel |