Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
excel chart and data don't match, help
I have a large spreadsheet and when I try to plot columns in a scatter plot I
don't get what is in the columns. For example this is what you get when you click on a ponit in the chart, Series 1 Point "1.230" (2371, 18.41) The actual data point is 1.230,18.41, the 2371 is nowhere to be found in either column or the whole spreadsheet for that matter. Help! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
excel chart and data don't match, help
How do you have your data organized? If you repost with an example of 5 -
10 rows, I'll try to reproduce your problem and see if I have a solution. "uwcoug" wrote in message ... I have a large spreadsheet and when I try to plot columns in a scatter plot I don't get what is in the columns. For example this is what you get when you click on a ponit in the chart, Series 1 Point "1.230" (2371, 18.41) The actual data point is 1.230,18.41, the 2371 is nowhere to be found in either column or the whole spreadsheet for that matter. Help! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
excel chart and data don't match, help
I just now figured out my problem. In my 4500 row by O column wide
spreadsheet, I had 3 cells that were blank. By putting in -99 for missing values, the plot gets the right data pairs. Kelly, thank you for responding. Cheers, uwcoug |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I number format the Data Table in an Excel Chart? | Charts and Charting in Excel | |||
Updating Excel OLE chart data in PPT from Excel | Charts and Charting in Excel | |||
Excel 2002 chart does not update when worksheet data changes | Charts and Charting in Excel | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel |