| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Using variables in Chart Ranges
I have created a chart with a Value (data range) of €˜='Raw Data'!$S$3:$S$6
but I need to make the number of rows to chart variable. I have created a variable called €˜numrows with the COUNTA option. How do I replace the $S$6 with numrows so when I import data into the Raw Data worksheet, the proper number of rows will be charted? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In a 2 Y-Axis chart, how do I assign data ranges to an axis? | Charts and Charting in Excel | |||
| Excel2000: Weird chart behaviour | Excel Discussion (Misc queries) | |||
| Activating a Chart object | Charts and Charting in Excel | |||
| Combination chart with three data ranges | Charts and Charting in Excel | |||
| Multiple Ranges for a Chart | Charts and Charting in Excel | |||
Threaded Mode
