Dynamic Ranges in a Chart (Data pulled from Pivot)

[SparkleUnicorn]

Is it possible using indirect and offset to have a dynamic range for a bar chart? I'm working on a pipeline Gantt chart; however, due to the complexity of the chart, I can't link directly to the pivot data. I need to hard format the chart, and refer to fields within the pivot table.

For some reason, in the Select Data for my bar chart, I'm not able use offset and indirect to dynamically pull data from the pivot table. Likewise, I've also been unable as of yet to reference the actual data through PivotTable1[Name].

I'm trying to get a sample together, but this includes quite a bit of proprietary information so I'm hoping that some of this might make sense.

I'll keep working on uploading a sample, I'm not having much luck because anything I change a name of a client, it throws all my charts off.

Thanks,
K

 

[Hui]

K

You have two choices to extract data from Pivot tables for charting
The easiest is to use a Pivot Chart
They allow filtering/sorting of the data directly in the PT

You can also extract data using Named Formula to locate the data boundaries and hence chart directly from named formula connected to the PT

The easiest way is for you to post a file here or email it to me