scatter chart series ordering problem

lochnagar2020

New Member
Joined
Jun 19, 2020
Messages
5
Office Version
  1. 2010
Platform
  1. Windows
Hi,

I have an issue with a scatter chart that I'm hoping to get some advice / help with.

Whenever I built a scatter chart in Excel 365, I've found (more often than not) that if I change the order number of a series (i.e. the number quoted at the end of the SERIES(series name, x values, y values, order number) when viewed in the formula bar.), Excel drastically changes the formatting (mainly colour) of all series; which is incredibly frustrating. It tends to occur if I make large changes e.g. change the order number of series 24 to 1. I have tried gradually reducing the order number of a series e.g. 24 to 20, then to 15, then to 10 etc. but when changed to 1, the formatting goes awry.

I have googled the issue, but to no avail. Just wondering if anyone has encountered the same issue, and how / if they managed to resolve it. Any help would be much appreciated.

Kind regards,
Lochnagar2020
.
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
5,271
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
I can't replicate this misbehavior.

Does it also happen if you change the order using the up and down buttons in the Select Data dialog?

Have you customized the formatting of the series?
 
Upvote 0

Forum statistics

Threads
1,186,330
Messages
5,957,251
Members
438,295
Latest member
nm005

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