connect line to data points with missing data in between

Z

ziak

Hi All:

I have 10 years worth of currency data that i need to graph by month. Many
months do not have any data - adding a "zero" makes the line plummet to zero.
Keeping it blank leaves a missing space between the previous and next data
points.

How do I connect the line with missing data points in between?

Thanks!!
 
W

Whitney

Wow, I got it. (After a dozen unanswered searches and fistfulls of pulled
hair...)

In Excel 2007:
- Select the plot area of the chart
- Right click and go to "Select Data"
- Click "Hidden and Empty cells" in the bottom left corner of the Select
Data Source box
- For 'Show empty cells as:' select "Connect data points with line"

:)
 

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

missing data points causes my line graph not to connect 8
Line charts with missing data points in Excel 2007 2
Line Drawing Between Separated Data Points ? 2
How do I chart missing data points in a scatter graph? 2
Connection Lines Between Data Points 2
Help with "clusters" of plotted data 2
space between y axis and data points.. 3
Line graph showing '0' points 1

Top