ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Chart Data Table (https://www.excelbanter.com/excel-worksheet-functions/227522-chart-data-table.html)

Joe R @ AA[_2_]

Chart Data Table
 
On a YTD Chart, I need the data table to show blanks, not zeroes for future
months.
The data sheet which the chart references for the numbers are blank. The
cell formula uses "" if the current month is less then the month for that
column. How do I blank out the zeroes?


All times are GMT +1. The time now is 04:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com