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: 23
Default Charting Selective Data

I am trying to create a chart of monthly percent gain across a given
year, and I have separated the data into two rows:

Jan Feb Mar Apr ........... Dec
#N/A #N/A 5% 12% .......... 0%

The #N/A signifies that there is no data for the given months, and the
0% signifies that the month is not completed. They are a result of the
formula being used to grab the data.

I'm not sure of what method is the best, but I simply want a chart
that only displays the months that contain a percent value (other than
0%). Any help would be greatly appreciated with this problem.

Thank you.
-bgetson

 
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
Excel External Data Selective Import. Nitrox50 Excel Discussion (Misc queries) 0 January 20th 07 09:49 AM
Selective extraction of data eddy56 Excel Discussion (Misc queries) 4 August 2nd 06 09:44 PM
Including data in data table but not charting as a series or point pepper76 Charts and Charting in Excel 4 August 2nd 06 03:20 AM
Need help merging selective data JM Excel Discussion (Misc queries) 1 January 5th 06 06:20 PM
how can I calculate VAT for selective data in the same column of a Pathma Excel Worksheet Functions 2 November 22nd 05 04:33 PM


All times are GMT +1. The time now is 12:15 AM.

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

About Us

"It's about Microsoft Excel"