Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting help for a novice?
I have a value in Column A and a calculated value in column B
=if(A1,A1*14,"") I want to plot column B on a chart, however where there is no data in A then the chart plots B as a zero, but I don't want it to plot anything if there is no data. Can anyone help this relative novice? Thanks in anticipation Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
novice needs info | New Users to Excel | |||
Novice needs help. | Excel Discussion (Misc queries) | |||
Novice Needs Help with Formulas | Excel Worksheet Functions | |||
Help And Advive For A Novice | Excel Discussion (Misc queries) | |||
Custom charting - Stacked charting with a line | Charts and Charting in Excel |