Chart Formatting Stops working when workbook closes

nniedzielski

Well-known Member
Joined
Jan 8, 2016
Messages
566
Office Version
  1. 2019
Platform
  1. Windows
I have an X, Y chart that plots value impact. this is it: (Data Labels are clear and centered in the circles, beautiful)

1620391294133.png

However, when I close the file and open it later to add a new row, the data label does not show in the circle, like this:

1620391365258.png


It is in Windows 2016, and saved as an XLSX file, and i cannot find anything on the net that explains why the data labels being added to the center will not save when i close the file.

can anyone help with this?

Note: I also tried moving everything to a new workbook also, and it did the same thing.
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,983
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
I assume you mean Excel 2016, because there's no Windows 2016.

Did you see my last follow-up to your other post about this? I cannot mimic the behavior you describe if the chart and labels are set up the way I describe. There's no reason that Excel 2016 would work differently than Microsoft 365, which I'm using. Every version since 2013 would work this way. I even closed and reopened my test workbook numerous times to make sure that didn't cause any issues.
 

Forum statistics

Threads
1,148,159
Messages
5,745,116
Members
423,925
Latest member
globaltlg

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