Can you create 1 chart that will update based on filtered data?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Diane - 08 Aug 2006 15:09 GMT

I have budget data for 120 or so medical centers in rows. I filter this data
by center. Is there a way to create one chart that will present data for
only the center currently selected in the filter or would I have to create
120 diff charts?

Thank you,

Reply to this Message

Andy Pope - 09 Aug 2006 09:52 GMT

Hi,

Create you chart on all the data. Assuming your total data does not
exceed the charts limits.

Make sure the 'plot visible cells only' option is on. Tools > Options >
Chart.

If the chart is located near the data to be filtered you will need to
change the Move and size properties of the chart object. Double click
the chart area and see options on the Properties tab.

You should then be good to go and filter the data.

Cheers
Andy

> I have budget data for 120 or so medical centers in rows. I filter this data
> by center. Is there a way to create one chart that will present data for
> only the center currently selected in the filter or would I have to create
> 120 diff charts?
>
> Thank you,

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message

Diane - 09 Aug 2006 14:14 GMT

Thank you!!! You're wonderful!

> Hi,
>
[quoted text clipped - 19 lines]
> >
> > Thank you,

Reply to this Message

Andy Pope - 09 Aug 2006 14:30 GMT

:blush: thank you :)

> Thank you!!! You're wonderful!
>
[quoted text clipped - 21 lines]
>>>
>>>Thank you,

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message