Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 1st 04, 05:15 PM
Ken
 
Posts: n/a
Default 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   Report Post  
Old December 1st 04, 05:34 PM
Barb Reinhardt
 
Posts: n/a
Default

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   Report Post  
Old December 1st 04, 05:43 PM
Ann Scharpf
 
Posts: n/a
Default

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.



Reply
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
Format Data Series Markers KB Charts and Charting in Excel 1 November 30th 04 03:37 AM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 03:30 AM
multiple scatter graphes how to plot 3 sets of data for x y on th. frances Charts and Charting in Excel 2 November 29th 04 08:22 PM
Bar Chart for Text Data RichIII Charts and Charting in Excel 1 November 29th 04 07:03 PM
Named dynamic ranges, copied worksheets and graph source data 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.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017