Thread: Chart & Data Table Range displays

Hi,

I am trying to show a Stacked Area chart based off a table of 24 months of information. In this chart I am also selecting a data table to be displayed.

When the table of information extends for 24 months, everything comes up fine - the length of the data table range matches the length of the range being graphed. When this range reduces to anything below 24 months (let's say 11, whilst the 24 columns are still selected), the graph adjusts to show only the 11 months of data (via the NA-dealing properties of charts), yet the data table still displays 24 months (including a whole bunch of lovely NAs).

I have shown this visually - anyone know a way to adjust the data table without changing the range from 24 to 11 months?

Thanks in advance,
K

Thanks Andy. I was originally hoping to avoid named ranges being involved with my charts, but seems the bullet has to be bitten.