Remember Me?

#1
December 1st 04, 05:15 PM
 Ken Posts: n/a
Formulas in source data

I have a chart with twelve months of data that is generated by using a fomula:
Cell A1 has the following: =IF(A25,A2*A3,"")
Cell B1 contains: =IF(B25,B2*B3,"")

These fomulas go out for twelve cells and are the source data for my line
chart.

I have only the first six cells with data in them and when I set up my chart
I get the first six data points plus six data points at the zero value of the
Y-axis.

Can I suppress the data points where the formula returns a null value?

TIA.

#2
December 1st 04, 05:34 PM
 Barb Reinhardt Posts: n/a

You can use the NA() function to do this.

"Ken" wrote in message
...
I have a chart with twelve months of data that is generated by using a

fomula:
Cell A1 has the following: =IF(A25,A2*A3,"")
Cell B1 contains: =IF(B25,B2*B3,"")

These fomulas go out for twelve cells and are the source data for my line
chart.

I have only the first six cells with data in them and when I set up my

chart
I get the first six data points plus six data points at the zero value of

the
Y-axis.

Can I suppress the data points where the formula returns a null value?

TIA.

#4
December 1st 04, 05:43 PM
 Ann Scharpf Posts: n/a

Jon Peltier has an excellent example of this type of chart formatting:

http://peltiertech.com/Excel/Charts/...nalChart1.html

"Ken" wrote:

I have a chart with twelve months of data that is generated by using a fomula:
Cell A1 has the following: =IF(A25,A2*A3,"")
Cell B1 contains: =IF(B25,B2*B3,"")

These fomulas go out for twelve cells and are the source data for my line
chart.

I have only the first six cells with data in them and when I set up my chart
I get the first six data points plus six data points at the zero value of the
Y-axis.

Can I suppress the data points where the formula returns a null value?

TIA.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post KB Charts and Charting in Excel 1 November 30th 04 03:37 AM Jon Peltier Charts and Charting in Excel 4 November 30th 04 03:30 AM frances Charts and Charting in Excel 2 November 29th 04 08:22 PM RichIII Charts and Charting in Excel 1 November 29th 04 07:03 PM WP Charts and Charting in Excel 1 November 28th 04 05:19 PM

All times are GMT +1. The time now is 04:05 AM.