Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel External Data Selective Import. | Excel Discussion (Misc queries) | |||
Selective extraction of data | Excel Discussion (Misc queries) | |||
Including data in data table but not charting as a series or point | Charts and Charting in Excel | |||
Need help merging selective data | Excel Discussion (Misc queries) | |||
how can I calculate VAT for selective data in the same column of a | Excel Worksheet Functions |