Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding a data series to a chart with variable inputs.
I recorded a macro to make a chart, and wanted to replace some of the series
with variables. Here is the part that I get the error on: "advanced homeland securityact" is the name of the tab the data is on and chrt is a variable for the row. ActiveChart.SeriesCollection(2).XValues = _ "='Advanced Homeland Securityact'!R1C9:R1C20" ActiveChart.SeriesCollection(2).Values = _ "='Advanced Homeland Securityact'!" & Range(Cells(chrt, 9), Cells(chrt, 20)) ActiveChart.SeriesCollection(2).Name = "=""actuals$""" THanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart data scrunches to left when adding X axis date series | Charts and Charting in Excel | |||
Selecting series in a chart based on a range and manual inputs | Excel Discussion (Misc queries) | |||
adding a line to show average for a data series on a chart | Charts and Charting in Excel | |||
Adding data series to chart via macro | Charts and Charting in Excel | |||
Adding a data series to a chart | Excel Programming |