Learn how to show charts with hidden data cells in Excel. When there is data that is hidden in your table, Excel will not show that information in the chart.

Outgoing is formatted as negative numbers.<BR><BR>When graphing the data, I would like the absolute value of the outgoing monies displayed, because it more clearly shows the picture of what I'm ...

3. Repeat the value above in Excel Depending on where you receive your data, you might find that some blank cells should contain the value in the cell above.