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!
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!
