If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Error causing the selected data not to show
I'm making a chart that is for a physics class, heres the problem. I graph
volume vs. radius and it works fine. so i then calculate radius squared and graph volume and r^2 but it show a weird line then in the first tab of information (using x-y scatter chart) is say below that the data can not be desplayed because the graph is to complex. Its 2 sources of date . . .TO COMPLEX????. any ideas what the deal is. thanks |
#2
|
|||
|
|||
You will have more control over the chart source data if you click on
the Series tab. On the Data Range tab, you can only see the data if it's in a well defined rectangular range. On the series tab, you can define the ranges for x values, y values, and name of each series in turn. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Bretticus wrote: I'm making a chart that is for a physics class, heres the problem. I graph volume vs. radius and it works fine. so i then calculate radius squared and graph volume and r^2 but it show a weird line then in the first tab of information (using x-y scatter chart) is say below that the data can not be desplayed because the graph is to complex. Its 2 sources of date . . .TO COMPLEX????. any ideas what the deal is. thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Problems with converting data held in an Excel spreadsheet to Word | mark Gray | Mailmerge | 6 | July 8th, 2004 10:54 AM |
get data from a text file and insert them in datasheet to show a chart in VBA | Frank | Worksheet Functions | 1 | June 9th, 2004 09:27 PM |
Mial merge data base problems | Rachael | Mailmerge | 16 | May 21st, 2004 06:22 PM |
How to filter data to show similar entries in a worksheet. | Tony Clark | Worksheet Functions | 1 | January 14th, 2004 03:25 AM |
counting yes' (that are selected from data validation) | _Bigred | Worksheet Functions | 1 | December 22nd, 2003 02:40 AM |