Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel chart plot area not showing data
am I missing some part of excel as I cannot make a chart ( even the simple
ones) the points do not show in the plot area, ( or maybe I am doing some thing really stupid...it sure feels that way at this point! |
#2
|
|||
|
|||
One possibility is that the "numbers" you are trying to plot are really
text. What does =COUNT(xRange) and =COUNT(yRange) return? If zero, Excel is not recognizing any numbers. In that case, copy a blank cell, select the ranges in question, and Edit|Paste Special|Add to coerce text to numbers. Jerry samm wrote: am I missing some part of excel as I cannot make a chart ( even the simple ones) the points do not show in the plot area, ( or maybe I am doing some thing really stupid...it sure feels that way at this point! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
pie-charting non-numeric data | Charts and Charting in Excel | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
BUG?: Excel scatter chart: will not plot x-values | Excel Discussion (Misc queries) |