| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Charts with Data Tables
Need your help!
I'm creating charts to plot YOY and MTD comparisons of data. My charts' data tables keep populating future months with zeroes even though the reference data cells are blank. How can I get just the future months cells to be blank and not show zeroes? Regards, Joe |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Charts with Data Tables
Adjust to suit but the basics are to trap for a blank cell and return a
blank if one is found. =IF(A1="","",A1) =IF(AND(A1="",(A2="")),"",A1+A2) Gord Dibben MS Excel MVP On Tue, 14 Apr 2009 08:20:04 -0700, Joe R @ AA wrote: Need your help! I'm creating charts to plot YOY and MTD comparisons of data. My charts' data tables keep populating future months with zeroes even though the reference data cells are blank. How can I get just the future months cells to be blank and not show zeroes? Regards, Joe |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Charts and data tables different info | Charts and Charting in Excel | |||
| Formatting Data Tables in Charts | Charts and Charting in Excel | |||
| Adding new data to tables and charts in excel sheets from 97/2003 | Excel Worksheet Functions | |||
| Data Tables in Charts - Totals | Charts and Charting in Excel | |||
| Putting data tables with charts | Charts and Charting in Excel | |||
![Joe R @ AA[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
