Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referring to data series in a chart
Hi,
I currently have a chart with dataseries that are named "Smith", "Jones" "Brown" etc. These names are changeable depending on data in the sheet. For example dataseries 1 name is cell A10. If cell A10 says "Jones" then the dataseries is called Jones and if it says "Smith" then the dataseries is called Smith. My code is currently says this; ActiveChart.seriescollection("SMITH").Select With Selection.Border .LineStyle = xlAutomatic End With With Selection .MarkerStyle = xlNone End With End If This works if the series is still called Smith (if cell A10 contents are Smith). However if the series name changes to "Jones" (cell A10 contents changes to Jones) then my code doesn't work as it is referring to a series that is no longer called Smith. How can I overcome this? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not plot a data series in a chart but still display in data table | Charts and Charting in Excel | |||
chart with two data series and two colors for each data series | Charts and Charting in Excel | |||
chart series data corrupted when chart has no data | Excel Programming | |||
automatically expand chart data series as data is added | Charts and Charting in Excel | |||
chart data series -- plot a table as a single series | Charts and Charting in Excel |