Chart that will automaticaly adjust its series based on pivot table.

Martin_H

New Member
Joined
Aug 26, 2020
Messages
26
Office Version
  1. 2016
Platform
  1. Windows
Morning all,

another day, another problem...

So lets just say that we have:

Workbook_one.xlsx basic daily export out of database with only one sheet. Lots of data, hard to read. Number of rows varies, number of columns stay same.

Workbook_two.xlsm this workbook is used for processing the data from Workbook_one. I am using a pivot table which I am completely fine with. Again, number of rows varies, number of columns stay same.

Workbook_three.xlsm (shared!) this workbook is used for chart presentations. In this workbook, I would like to have a basic column type of chart, with source data linked to the Workbook_two.xlsm.

As I said, number of rows varies so the column type of chart could be one day bigger and on another day smaller. The problem is, I do not know how to create a chart that will automaticaly adjust its series to constantly changing pivot table size in Workbook_two.xlsm. (Again, number of rows in pivot table varies but number of columns stay same).

Any ideas please?


Thank you.
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

GraH

Well-known Member
Joined
Mar 22, 2020
Messages
702
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Maybe use a pivot chart directly?
 

Watch MrExcel Video

Forum statistics

Threads
1,122,246
Messages
5,595,044
Members
413,963
Latest member
teggl97

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top