| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
CHARTING W/INDIRECT SERIES
I have a data series to chart, say A1..A20. As I input new data I insert a
cell in A1 and enter the data. However on my chart source data it changes to a new series of source data to B1..B21 when I insert "Shift Down" the cells and insert new data. I want the data series to remain A1..A20. I have tried (INDIRECT and OFFSET) but I get" Function not Valid" Any ideas would be greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I display multiple series in a pie chart? | Charts and Charting in Excel | |||
| Plotting different length series in a chart | Charts and Charting in Excel | |||
| graphing two series on x axis | Charts and Charting in Excel | |||
| How do I force a series in a Bar-Line Chart to be a Bar? | Charts and Charting in Excel | |||
| Format Data Series Markers | Charts and Charting in Excel | |||
Threaded Mode
