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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting help for a novice?
=if(A1,A1*14,NA()) should cure it on the chart.
If you don't want the NA# to show in your data sheet, you can hide it with conditional formatting. -- David Biddulph "Dave Jones" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting help for a novice?
Can you advise me on what expression to use in conditional formatting? I
have tried Cell value = #N/A and White font, but this doesn't work Thanks Dave "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... =if(A1,A1*14,NA()) should cure it on the chart. If you don't want the NA# to show in your data sheet, you can hide it with conditional formatting. -- David Biddulph "Dave Jones" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting help for a novice?
Formula is: =ISNA(B1)
-- David Biddulph "Dave Jones" wrote in message ... Can you advise me on what expression to use in conditional formatting? I have tried Cell value = #N/A and White font, but this doesn't work "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... =if(A1,A1*14,NA()) should cure it on the chart. If you don't want the NA# to show in your data sheet, you can hide it with conditional formatting. "Dave Jones" wrote in message ... 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 |
Reply |
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 |