Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 21
Default 2003 Excel Chart with zero data

I have a chart that shows the fiscal year. In the months that currently do
not have data it is charting to a zero for the month. How can I get the
chart not to show the next month's that have a zero for a value? The catch
is that some months maybe zero and the months that do not have a value are
currently empty. Below is the formula that I am currently using.

=IF(SUM('Global KPI Monitoring chart'!F7:F8)=0,IF(AND('Global KPI Monitoring
chart'!F7="",
'Global KPI Monitoring chart'!F8=""),"",0),SUM('Global KPI Monitoring
chart'!F7:F8))
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,722
Default 2003 Excel Chart with zero data

Instead of an output of "", have the formula output the #N/A error (as charts
recognize this data as not applicable)

I believe something like this:

=IF(SUM('Global KPI Monitoring chart'!F7:F8)=0,IF(AND('Global KPI Monitoring
chart'!F7="",
'Global KPI Monitoring chart'!F8=""),NA(),0),SUM('Global KPI Monitoring
chart'!F7:F8))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"C Kreig" wrote:

I have a chart that shows the fiscal year. In the months that currently do
not have data it is charting to a zero for the month. How can I get the
chart not to show the next month's that have a zero for a value? The catch
is that some months maybe zero and the months that do not have a value are
currently empty. Below is the formula that I am currently using.

=IF(SUM('Global KPI Monitoring chart'!F7:F8)=0,IF(AND('Global KPI Monitoring
chart'!F7="",
'Global KPI Monitoring chart'!F8=""),"",0),SUM('Global KPI Monitoring
chart'!F7:F8))

  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 21
Default 2003 Excel Chart with zero data

Luke-
If I do that, I get ?Name error

"Luke M" wrote:

Instead of an output of "", have the formula output the #N/A error (as charts
recognize this data as not applicable)

I believe something like this:

=IF(SUM('Global KPI Monitoring chart'!F7:F8)=0,IF(AND('Global KPI Monitoring
chart'!F7="",
'Global KPI Monitoring chart'!F8=""),NA(),0),SUM('Global KPI Monitoring
chart'!F7:F8))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"C Kreig" wrote:

I have a chart that shows the fiscal year. In the months that currently do
not have data it is charting to a zero for the month. How can I get the
chart not to show the next month's that have a zero for a value? The catch
is that some months maybe zero and the months that do not have a value are
currently empty. Below is the formula that I am currently using.

=IF(SUM('Global KPI Monitoring chart'!F7:F8)=0,IF(AND('Global KPI Monitoring
chart'!F7="",
'Global KPI Monitoring chart'!F8=""),"",0),SUM('Global KPI Monitoring
chart'!F7:F8))

  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 21
Default 2003 Excel Chart with zero data

Luke-
I got the formula to work, however it is still showing a value of zero on my
chart.
Any suggestions?

"Luke M" wrote:

Instead of an output of "", have the formula output the #N/A error (as charts
recognize this data as not applicable)

I believe something like this:

=IF(SUM('Global KPI Monitoring chart'!F7:F8)=0,IF(AND('Global KPI Monitoring
chart'!F7="",
'Global KPI Monitoring chart'!F8=""),NA(),0),SUM('Global KPI Monitoring
chart'!F7:F8))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"C Kreig" wrote:

I have a chart that shows the fiscal year. In the months that currently do
not have data it is charting to a zero for the month. How can I get the
chart not to show the next month's that have a zero for a value? The catch
is that some months maybe zero and the months that do not have a value are
currently empty. Below is the formula that I am currently using.

=IF(SUM('Global KPI Monitoring chart'!F7:F8)=0,IF(AND('Global KPI Monitoring
chart'!F7="",
'Global KPI Monitoring chart'!F8=""),"",0),SUM('Global KPI Monitoring
chart'!F7:F8))

  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,722
Default 2003 Excel Chart with zero data

Hmm. You might want to take a look at dynamic charting techniques to help
limit the amount of data going into your chart.

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

It appears you are trying not only keep the data from months that have no
data from being plotted, but also keep those months from appearing on the
axis, correct?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"C Kreig" wrote:

Luke-
I got the formula to work, however it is still showing a value of zero on my
chart.
Any suggestions?

"Luke M" wrote:

Instead of an output of "", have the formula output the #N/A error (as charts
recognize this data as not applicable)

I believe something like this:

=IF(SUM('Global KPI Monitoring chart'!F7:F8)=0,IF(AND('Global KPI Monitoring
chart'!F7="",
'Global KPI Monitoring chart'!F8=""),NA(),0),SUM('Global KPI Monitoring
chart'!F7:F8))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"C Kreig" wrote:

I have a chart that shows the fiscal year. In the months that currently do
not have data it is charting to a zero for the month. How can I get the
chart not to show the next month's that have a zero for a value? The catch
is that some months maybe zero and the months that do not have a value are
currently empty. Below is the formula that I am currently using.

=IF(SUM('Global KPI Monitoring chart'!F7:F8)=0,IF(AND('Global KPI Monitoring
chart'!F7="",
'Global KPI Monitoring chart'!F8=""),"",0),SUM('Global KPI Monitoring
chart'!F7:F8))



  #6   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 21
Default 2003 Excel Chart with zero data

Luke-
I am doing a chart for fy and from Nov - Aug we do not have data. Instead
of the chart leaving the point blank where the data does not exist it
considers it a zero value and is charting it as a zero.

"Luke M" wrote:

Hmm. You might want to take a look at dynamic charting techniques to help
limit the amount of data going into your chart.

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

It appears you are trying not only keep the data from months that have no
data from being plotted, but also keep those months from appearing on the
axis, correct?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"C Kreig" wrote:

Luke-
I got the formula to work, however it is still showing a value of zero on my
chart.
Any suggestions?

"Luke M" wrote:

Instead of an output of "", have the formula output the #N/A error (as charts
recognize this data as not applicable)

I believe something like this:

=IF(SUM('Global KPI Monitoring chart'!F7:F8)=0,IF(AND('Global KPI Monitoring
chart'!F7="",
'Global KPI Monitoring chart'!F8=""),NA(),0),SUM('Global KPI Monitoring
chart'!F7:F8))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"C Kreig" wrote:

I have a chart that shows the fiscal year. In the months that currently do
not have data it is charting to a zero for the month. How can I get the
chart not to show the next month's that have a zero for a value? The catch
is that some months maybe zero and the months that do not have a value are
currently empty. Below is the formula that I am currently using.

=IF(SUM('Global KPI Monitoring chart'!F7:F8)=0,IF(AND('Global KPI Monitoring
chart'!F7="",
'Global KPI Monitoring chart'!F8=""),"",0),SUM('Global KPI Monitoring
chart'!F7:F8))

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
2003 Excel Radar Chart Data Label Position Bill Excel Discussion (Misc queries) 1 September 25th 08 02:48 PM
multiple data series in an x-y scatter chart - Excel 2003 Excel 2003 Charts and Charting in Excel 6 August 21st 07 12:38 AM
How do I change the order of the data in a pie chart - excel 2003 carincamille Charts and Charting in Excel 1 February 12th 07 08:35 PM
Column chart not displaying some data points - Excel 2003 Don Burgess Charts and Charting in Excel 3 November 28th 06 07:20 PM
Stacked Bar Chart - Data Labels:Percentage - Excel 2003 seven_percent Charts and Charting in Excel 0 November 17th 06 03:16 PM


All times are GMT +1. The time now is 05:03 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"