I have a line chart with multiple series. In the data, each series has blank cells so I end up with non-continuous lines. Because I have multiple series (each row a different series), I can't hide columns as the blanks are not all in the same column. Anyway to get Excel to connect the dots within a series even if there are blanks between them? Thanks
Last edited by ChemistB; 06-26-2009 at 05:43 PM.
ChemistB
My 2¢
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Replace blanks with =NA()?
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
That does it! Thanks !
ChemistB
My 2¢
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Chart Tools > Design > Data > Select Data > Hidden & Empty cells > Show empty cells as > Connect data points with a line.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks