Blank cells between data in Excel chart
Blank cells between data in Excel chart
(OP)
I built a chart using "lines on 2 axes". The first data row is filled (i.e. Monday thru Friday) but the second row is not completely filled (i.e. Tuesday and Thurday only).
The end result is the chart showed the line of the 1st data row and 2 dots with the 2nd data row. It's normal because under Monday, Wednesday and Friday are blank cells.
What I would like to have is Excel to connect a line between the 2 dots (Tues and Thurs). Thank you for your help.
Last time Mala gave me a tip for another problem but I don't know how to post my appreciation. Please show me the way. Thanks again.
The end result is the chart showed the line of the 1st data row and 2 dots with the 2nd data row. It's normal because under Monday, Wednesday and Friday are blank cells.
What I would like to have is Excel to connect a line between the 2 dots (Tues and Thurs). Thank you for your help.
Last time Mala gave me a tip for another problem but I don't know how to post my appreciation. Please show me the way. Thanks again.





RE: Blank cells between data in Excel chart
RE: Blank cells between data in Excel chart
Excel has a feature for handling missing chart data.
You can choose to:
Either leave gaps for missing data
Or Interpolate values for missing data
Strangely enough this feature is nowhere to be found on the chart toolbar or the chart dialog boxes. You access it from Tools>Options>Chart.
One wonders why the designers of Excel chose to put it in such an unlikely place...
Eurobum: You express appreciation by voting the reply as useful. At the bottom of each post u'll find 2-3 hyperlinks. The left-most of them looks like:
Let Eurobum know
this post was helpful!
You simply click this link and your appreciation is registered in the form of a Star credited to the respondent, though the latter doesn't get to know who voted. It'd be more transparent if you just additionally post a line of appreciation as a reply in the same thread.
And PLEASE friends - I'm just showing Eurobum the way. Never think I'm plugging for votes...
RE: Blank cells between data in Excel chart
RE: Blank cells between data in Excel chart
I did find out about "inteporlating" as Mala described above. It did work out fine. Thanks again. Have a nice weekend.