LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
novice needs info Mac New Users to Excel 1 June 17th 06 09:34 PM
Novice needs help. aphwood Excel Discussion (Misc queries) 1 October 4th 05 07:56 PM
Novice Needs Help with Formulas Donna123 Excel Worksheet Functions 1 September 4th 05 03:40 PM
Help And Advive For A Novice Joe Williams Excel Discussion (Misc queries) 1 May 26th 05 03:49 PM
Custom charting - Stacked charting with a line Randy Lefferts Charts and Charting in Excel 3 March 3rd 05 03:10 AM


All times are GMT +1. The time now is 05:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"