Posted to microsoft.public.excel.charting

Posts: n/a

Chart ignoring formulas but only plotting formula results

I am creating a line chart where the source data is the result of an =IF
formula. How do I get the chart to only plot the cells where there is a
result? Currently the chart is plotting a zero value for all the cells where
the formula does not yet show a result.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Some formula results will not show up in the cell	Space Elf	Excel Worksheet Functions	3	August 1st 05 01:26 AM
calculating results in formulas	Linda	Excel Discussion (Misc queries)	9	July 6th 05 09:20 AM
How do I prevent Excel from plotting a cell w/ a formula as a "ze.	Hatchet_Jack	Charts and Charting in Excel	1	February 9th 05 10:31 PM
How do I prevent Excel from plotting a cell w/ a formula as a "ze.	Bearclaw Chris	Charts and Charting in Excel	0	February 9th 05 04:59 PM
Chart Formulas	BillCPA	Excel Discussion (Misc queries)	1	February 1st 05 02:52 AM

All times are GMT +1. The time now is 03:54 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us