Connecting missing points with a dotted line

G

Guest

Hi,

I have a question about charts. I have a solid line connecting each of my
points in a time-series (days in a month). However, I am missing several
points. For example, lets say Tuesday-Friday of the first week is missing. I
want to connect Monday to Saturday using a dotted line. Right now the cells
for Tuesday-Friday are blank, so it does not draw anything. How can I do this
dotted line most efficiently? Thank you very much!
 
A

Andy Pope

Hi,

Assuming your data is in the range B2:B10 then put this formula in C2 and
copy down/

=IF(ISBLANK(B2),NA(),B2)

Create your chart based A1:C10. This will give you a line with gaps and a
line that interpolates between the gaps.
Select the series based on C2:C10 and format the line to have the same
colour but dotted or dashed line style.

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to convert a dotted line to a solid line in a line graph 1
Average of last 30 days 9
how do I draw a dotted line 1
Removing Plot lines between plot points on a line chart 1
Execute a FIND on formula results 4
WeekDay count between dates 13
Sum of data where a condition applies 1
Drawing a dotted line 6

Top