| 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 | |||
Linear Mode
