Soldato
- Joined
- 19 Jan 2005
- Posts
- 2,729
- Location
- Oxford/Bristol
...Add data to a chart that has different x-values to the set it was created with.
Used to be I'd make a chart then go to add data, highlight the new columns, in the pop-up window tell excel that the first column is new x-values and the top row are data headings and bosh! job done.
In 2010 I add data and it makes me select where the heading is, what the new x-column is and where the new y-values are. OK. It's fiddly but I'll play along. Problem is it keeps picking up the data headers eg Time ns in the new X-column and won't use the new values.
Anyone else come up against this and found a way around it?
Don't tell me to drag select the cells I want instead of column selecting because these data sets are thousands of values long.
Used to be I'd make a chart then go to add data, highlight the new columns, in the pop-up window tell excel that the first column is new x-values and the top row are data headings and bosh! job done.
In 2010 I add data and it makes me select where the heading is, what the new x-column is and where the new y-values are. OK. It's fiddly but I'll play along. Problem is it keeps picking up the data headers eg Time ns in the new X-column and won't use the new values.
Anyone else come up against this and found a way around it?
Don't tell me to drag select the cells I want instead of column selecting because these data sets are thousands of values long.