Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
excel 2007 version Rearange Columns
Hello from Steved
I know you can drag columns but for some reason I cannot drag the columns any ideas would be most welcome. excell 2007 version Thankyou. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
excel 2007 version Rearange Columns
Hi,
I am assuming that when you say 'drag columns' your are refereeing the the function in xl2003 of being able to adjust a data points value via the mouse and resizing or positioning the data point. If so, it is no longer possible as the feature has been removed from xl2007. If not can you explain further. Cheers And -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Steved" wrote in message ... Hello from Steved I know you can drag columns but for some reason I cannot drag the columns any ideas would be most welcome. excell 2007 version Thankyou. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
excel 2007 version Rearange Columns
Hello Andy from Steved
Thankyou for your reply Its a shame because I like to put the columns in order I like Oh well I'll will have to label for example City 1-City, Roskill 2-Roskill, Counties 3-Counties, and so on it's not a big deal. Thankyou. "Andy Pope" wrote: Hi, I am assuming that when you say 'drag columns' your are refereeing the the function in xl2003 of being able to adjust a data points value via the mouse and resizing or positioning the data point. If so, it is no longer possible as the feature has been removed from xl2007. If not can you explain further. Cheers And -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Steved" wrote in message ... Hello from Steved I know you can drag columns but for some reason I cannot drag the columns any ideas would be most welcome. excell 2007 version Thankyou. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
excel 2007 version Rearange Columns
I think we may be talking about different things.
You can change the series order still. Select the chart and then on the Design Tab Data group Select Data. There are Up/Down arrows in this dialog to change Series order. And you can still use the bounding areas that appear when a series is selected to move and resize data to be used by series. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Steved" wrote in message ... Hello Andy from Steved Thankyou for your reply Its a shame because I like to put the columns in order I like Oh well I'll will have to label for example City 1-City, Roskill 2-Roskill, Counties 3-Counties, and so on it's not a big deal. Thankyou. "Andy Pope" wrote: Hi, I am assuming that when you say 'drag columns' your are refereeing the the function in xl2003 of being able to adjust a data points value via the mouse and resizing or positioning the data point. If so, it is no longer possible as the feature has been removed from xl2007. If not can you explain further. Cheers And -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Steved" wrote in message ... Hello from Steved I know you can drag columns but for some reason I cannot drag the columns any ideas would be most welcome. excell 2007 version Thankyou. |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
excel 2007 version Rearange Columns
Thankyou.
"Andy Pope" wrote: I think we may be talking about different things. You can change the series order still. Select the chart and then on the Design Tab Data group Select Data. There are Up/Down arrows in this dialog to change Series order. And you can still use the bounding areas that appear when a series is selected to move and resize data to be used by series. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Steved" wrote in message ... Hello Andy from Steved Thankyou for your reply Its a shame because I like to put the columns in order I like Oh well I'll will have to label for example City 1-City, Roskill 2-Roskill, Counties 3-Counties, and so on it's not a big deal. Thankyou. "Andy Pope" wrote: Hi, I am assuming that when you say 'drag columns' your are refereeing the the function in xl2003 of being able to adjust a data points value via the mouse and resizing or positioning the data point. If so, it is no longer possible as the feature has been removed from xl2007. If not can you explain further. Cheers And -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Steved" wrote in message ... Hello from Steved I know you can drag columns but for some reason I cannot drag the columns any ideas would be most welcome. excell 2007 version Thankyou. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I revert to Excel 97-2003 from the 2007 version? | Setting up and Configuration of Excel | |||
How do I start the free trial version of Excel 2007 after I have . | Excel Discussion (Misc queries) | |||
Excel 2007 version differences | Excel Discussion (Misc queries) | |||
Autofilter only sorts the columns inlcluded (version 2007) | Excel Discussion (Misc queries) | |||
Excel 2007 Beta Version | Excel Discussion (Misc queries) |