Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a series of data that extends for 12 months and another series that
extends for 4 months. Plan vs actual. The actual series continues at a zero value after the data ends. Is there a way to chart only the 4 months on one series while the full 12 months is charted on the other series? |
#2
![]() |
|||
|
|||
![]()
Fill the empty cells in the short range with =NA() - will display as #N/A
and be ignored by chart best wishes -- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in email address "Big Red" wrote in message ... I have a series of data that extends for 12 months and another series that extends for 4 months. Plan vs actual. The actual series continues at a zero value after the data ends. Is there a way to chart only the 4 months on one series while the full 12 months is charted on the other series? |
#3
![]() |
|||
|
|||
![]() Works great for missing data points too. Thanks for the tip. On Wed, 8 Dec 2004 15:53:11 -0400, "Bernard Liengme" wrote: =NA() -- ================================================= Do you like wine? Do you live in South Florida? Visit the MIAMI WINE TASTERS group at http://groups.yahoo.com/group/miamiWINE ================================================= |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I display multiple series in a pie chart? | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel | |||
How do I force a series in a Bar-Line Chart to be a Bar? | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Hiding or Displaying Series In a Chart | Charts and Charting in Excel |