| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
plotting in excel 2007
Thanks for the tips i'll try em out,
Kevin "Andy Pope" wrote: Hi, I don't think you can stop Excel from creating and populating a chart by using the current area. You can restricted it, as you say, by selecting an empty. You can also select more than 1 cell, even in the middle of a area of data, and the chart will be based on that. Not exactly what you wanted by it should save time rather than waiting seconds, minutes even, for the chart to draw. Of course the real problem is remembering to select an empty or a few cells. Cheers Andy Kevin wrote: I'm having difficulties making graphs in 2007, mainly because when i hit the insert graph button excel says "i'll take it from here" and proceeds to make a graph of damn near the whole sheet which may contain 30-40 thousand data pairs. Is there no way to go back to the old wizard that let YOU pick what data you want to graph rather than Mr. Gates? I know that i can click on a location in the sheet where there's no data anywhere near it and it'll just open an empty plot but that shouldn't be the only way. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel plotting graphs | Charts and Charting in Excel | |||
| Plotting Y vs. X data in Excel | Charts and Charting in Excel | |||
| Excel 2007- prevent graph from plotting zeros | Charts and Charting in Excel | |||
| How do I change the Series plotting order in Excel 2007? | Excel Discussion (Misc queries) | |||
| Plotting data in Excel | Charts and Charting in Excel | |||
Hybrid Mode
