Indirect Cell in Charts

Originally Posted by Dave_A

I want to create a chart which i can update easily hopefully using indirect reference, on a difference sheet i want to be able to change a value and then that will change what data is included in table.

Are indirect cells able to be used in charts, or is there something similar???

Hi,

The Chart would be set up from a table, and how that table gets it's data should be irrelavant to the Chart.
The 'Indirect' if valid normally should be ok also in the Chart data area.

hth
---

Originally Posted by Dave_A

thanks for your help with this however im still having a few problems....

I've attached a sheet of with data if it helps explain things

I have in cells J3 & J4 which are able to be changed, this in effect changes the cell references in n3 & n4.

and they change the min max and average cells in J6, j7, j8, however i now want to make a graph, which has the cell references of n3 and n4, so at any time i can change the dates in the j3 and j4 and it will update the graph,

is there any way to be able to do this at all? im finding it pretty frustrating at the moment so your help would be great... i eventually want to do it for all rows of data, however im just trying to get one working first...

Hi,

one problem you have is the same formula for 3 different expected results.

If you type =(B2:B20) into a cell what do you expect the answer to be?

It is apparently the average (not something I would use).

try

=MIN(INDIRECT(N3):INDIRECT(N4))

=MAX(INDIRECT(N3):INDIRECT(N4))

=AVERAGE(INDIRECT(N3):INDIRECT(N4))

in J6 to J8.

hth
---