Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I would like to select the first chart in the sheet and set the min and max
values... the code says an object is not set... any help is appreciated! Dim MinVal As Range Dim MaxVal As Range Dim ch As Chart Set MinVal = ActiveSheet.Range("o17").Value Set MaxVal = ActiveSheet.Range("o16").Value ch = ActiveSheet.ChartObjects(1).Chart For Each ch In ActiveSheet.ChartObjects Select Case ch.ChartType Case xlLineMarkers With ch.Axes(xlCategory) .MinimumScale = MinVal .MaximumScale = MaxVal End With End Select Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Chart Property Confusion | Charts and Charting in Excel | |||
Still can select locked cells in protected sheet | New Users to Excel | |||
Error 1004 using array in Sheet select. | Excel Discussion (Misc queries) | |||
Copying chart to another sheet | Excel Worksheet Functions | |||
HELP required: Insert -> Hyperlink -> ???(no CHART sheet name)!!! | Excel Worksheet Functions |