| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart will put 0 data points on graphs for non-zero cells
I am attempting to make a chart with data from column A1-A7 using a scatter chart. The corresponding Y values in B1-B7 don't always have data in some cells. For example, if cells B1 & B2 are coded with if statements like: =IF(ISNUMBER(B1),$C$22-B1,"") The "blank" that is returned is forced to zero on the chart. If I have the conditional statement FALSE out, or TEXT out, the chart still forces the data point to zero. Any suggestions?? Regards, Matt -- rollinn95z ------------------------------------------------------------------------ rollinn95z's Profile: http://www.excelforum.com/member.php...o&userid=33571 View this thread: http://www.excelforum.com/showthread...hreadid=533512 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Chart will put 0 data points on graphs for non-zero cells
|
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Chart will put 0 data points on graphs for non-zero cells
Excellent. That worked great! Thanks! -- rollinn95z ------------------------------------------------------------------------ rollinn95z's Profile: http://www.excelforum.com/member.php...o&userid=33571 View this thread: http://www.excelforum.com/showthread...hreadid=533512 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting data from different cells for a chart | Charts and Charting in Excel | |||
| Charting data points and show a target range on the same chart. | Charts and Charting in Excel | |||
| Joining data points on a line chart | Charts and Charting in Excel | |||
| Formatting lines between data points in a line chart | Charts and Charting in Excel | |||
| To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Hybrid Mode
