When changing data source, my custom formatted charts revert back to default format settings, any guidance please?

Question

I'm in the process of creating a report that has a lot of customised graphs. I've got a sheet of all of these 'templates' to use, all with a large table of data to pull from.

I'm having issues though when copying the template and then selecting a different data source for each one, it keeps removing my custom formatting and reverting back to the default.

I've attached screenshots for reference, including what my advanced settings are currently on for 'Charts'. Custom graph on left, what it reverts to when I change data source on right.

When changing data source, I just pick a new 'legend entry', Horizontal stays the same

Advance Settings for 'Charts'

Thanks in advance

Answer 1

Hi Gloria,

Thanks for the reply. The graphs aren't pulling from a pivot table, it's just a standalone data table in another worksheet (which contains pretty much all formulae).

I'm using Microsoft Office 365 Business, version number 1812 (build 11126.20196 Click-to-run).

I've placed screenshots in a reply to the main post.

Thanks

Answer 2

Screenshots for data source below

Answer 3

Hi Ryan,

Could you please help record the video so that I can better understand your situation?

Best Regards,

Gloria

Answer 4

Hi Ryan,

Thanks for your reply.

I have tested from my side and when I copy the chart and change the select the new data, the format doesn't change.

I would like to check your detailed steps and test from my side again, could you please help record a video and share it with me in Private Message?

Best Regards,

Gloria

Answer 5

Hi Ryan,

If you are using pivot table, you can check the layout and format of it:

Select a cell in the pivot table> Analyze tab> Options> Layout & Format> Make sure the "Preserve cell formatting on update" on update is checked.

If it is not your scenario, please share your screenshots by clicking the insert image tool in the reply windows instead of dragging them.

Please also share your Office product name and full version number refer to this article: What version of Office am I using?

Best Regards,

Gloria