Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding Data to a Non-Contiguous Range in Excel 2007
I have a chart based upon a non-contiguous range. When I click on the chart
and "Select Data", and then click on the Edit button, I get the expected dialog box with Selected Values. However, I can't manually edit the values displayed, even after pressing F2. I click on the icon to take me to the spreadsheet, and it displays the non-contiguous values in dashed boxes. I hold down Ctrl and click the next box, and it de-selects everything. Then I try to add them all again, and it won't let me add the last range. Is there a limit in 2007 for how many non-contiguous values can be entered? Or am I missing something simple (I hope). |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding Data to a Non-Contiguous Range in Excel 2007
Hi,
Instead of clicking the Edit button, why not click the Chart data range box and edit in there? I have to say I not very happy with the way this area has been implimented by Microsoft, it is far harder than in 2003. I don't know that this will work, but when you are in the Edit Series dialog box, remore the entry that is currently there completely and then start again highlighting with the Ctrl key. It seems that Excel assumes you want to add (+) a range when you start to highlight again, even if you have already select the range in the box. If any of this helps, please click the Yes button. Cheers, Shane Devenshire "Tripp Martin" wrote: I have a chart based upon a non-contiguous range. When I click on the chart and "Select Data", and then click on the Edit button, I get the expected dialog box with Selected Values. However, I can't manually edit the values displayed, even after pressing F2. I click on the icon to take me to the spreadsheet, and it displays the non-contiguous values in dashed boxes. I hold down Ctrl and click the next box, and it de-selects everything. Then I try to add them all again, and it won't let me add the last range. Is there a limit in 2007 for how many non-contiguous values can be entered? Or am I missing something simple (I hope). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing a pivot table's data range in Excel 2007 | Excel Worksheet Functions | |||
Contiguous bars in Excel 2007 | Charts and Charting in Excel | |||
Non Contiguous data in Excel 2007 Pie Charts | Charts and Charting in Excel | |||
Excel copy formulas using non contiguous range | Excel Discussion (Misc queries) | |||
Adding Non-Contiguous Ranges | Excel Discussion (Misc queries) |