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 04:43 PM.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
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)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Replace blanks with =NA()?
Entia non sunt multiplicanda sine necessitate
That does it! Thanks !
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
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks