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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referring to data series in a chart
Fill in the real sheet name in place of Sheet1 in the first line:
With ActiveChart.SeriesCollection(Worksheets("Sheet1"). Range("A10").Value) With .Border .LineStyle = xlAutomatic End With .MarkerStyle = xlNone End With - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "keri" wrote in message ups.com... 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 |
Reply |
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 |