crashcoursetrading
New Member
I have two columns of data, one that updates when the column next to it has data in it.
The second column has a number in it. When there is more data, both columns update automatically. I dont have to type anything in.
Can I dynamically chart this data? I tried with tables but it relies on you typing the first column in. Is there a way around with this?
I used to do this with a counta() function to reorganise the chart range on a name, but having problems getting this to work in excel 365.
Does any one have an example or something I can have a look at?
Cheers
Alex Chatwin
The second column has a number in it. When there is more data, both columns update automatically. I dont have to type anything in.
Can I dynamically chart this data? I tried with tables but it relies on you typing the first column in. Is there a way around with this?
I used to do this with a counta() function to reorganise the chart range on a name, but having problems getting this to work in excel 365.
Does any one have an example or something I can have a look at?
Cheers
Alex Chatwin