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

Average bar charts with individual data points 2
half way though chart, lines between data points missing 1
Line Graph 1
Trend line with negatives Excel 2007 0
Hidden and Empty Cell Settings 0
Formatting data series - line between certain data points only 0
Connection Lines Between Data Points 2
Trendline when data points are missing 2

Top