Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
data order in a chart
I am plotting with stacked column charts with data in rows. However the data
I have is not in the order I want it on one of my charts. As in I want the data in column C to be to the left of the data in column A. I tried to select column C before column A, but Excel turned it around by itself. Is there a way of doing this besides selecting each series and manually changing each series? |
#2
|
|||
|
|||
Hi,
When creating the chart select the column C first and create the chart. Then highlight column A and drag the selection into the chart. It should then be added to the left, or on top if stacked. Or you could change the series order. Double click one of the sets of data and the change the order, which is on the Series Order tab. Cheers Andy OkieViking wrote: I am plotting with stacked column charts with data in rows. However the data I have is not in the order I want it on one of my charts. As in I want the data in column C to be to the left of the data in column A. I tried to select column C before column A, but Excel turned it around by itself. Is there a way of doing this besides selecting each series and manually changing each series? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
Andy -
Okie's series are in rows, so I think he's saying his cells are in the wrong order. This means rearranging the values in his source range. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Andy Pope wrote: Hi, When creating the chart select the column C first and create the chart. Then highlight column A and drag the selection into the chart. It should then be added to the left, or on top if stacked. Or you could change the series order. Double click one of the sets of data and the change the order, which is on the Series Order tab. Cheers Andy OkieViking wrote: I am plotting with stacked column charts with data in rows. However the data I have is not in the order I want it on one of my charts. As in I want the data in column C to be to the left of the data in column A. I tried to select column C before column A, but Excel turned it around by itself. Is there a way of doing this besides selecting each series and manually changing each series? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
changing proportion of chart and data table | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |