Scatter Chart Plot Order

Cartesian

New Member
Joined
May 3, 2019
Messages
11
Hi,

I am plotting a scatter graph with values in column C vs column E.
There are formulas from c1:c2000 and e1:e2000, and they have iferror statements to hide as "".
I would like the chart to populate automatically hence the 2000 rows, even though just say 123 rows have actual values (the rest today have "", but tomorrow may be 150 or 200 entries etc.)

If there is 123 entries and I change the data source to X= C1:C123 and Y= E1:E123 then these plot against each other in the order they appear down the list which is great, but
If i change to X= C1:C2000 and Y= E1:E2000, then the X axis order changes from 'down list' to sorted.

Can I have the data source to 2000 and have it plot as the data appears down the page?

Thanks!
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Forum statistics

Threads
1,224,817
Messages
6,181,149
Members
453,021
Latest member
Justyna P

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
Back
Top