How to create Line Charts automatically just in one click?

[Imran Magsi]

Hi Guys!
I am attaching a file inwhich i have lot of data and want to create Line/Trend Chart of services. Is there any way to create charts automatically or with one click.

[Olly]

I would normalise your data, then use a pivot chart, with a slicer to select the Center.

See attachment for an example - there's a macro 'RefreshData' which normalises the data into a hidden worksheet, then refreshes the pivot cache.

Click a Center in the slicer, to update the chart for just that Center.

Does this do something like what you wanted?

[Imran Magsi]

thank you dear.