hey guys,
i have a chart attached and for some reason, the line doesn't connect from the first point all the way to the last point
been trying to figure it out and running out of ideas
http://screencast.com/t/pJgTLpKNSSvh (link added b/c attached image doesn't work)
any help would be appreciated
thanks,
harry
Last edited by hluk; 07-05-2014 at 05:43 PM.
excel is awesome
Sorry but an image is useless here. We need to see your Excel file so we can see the data for the chart and also how the chart itself is built.
thanks for the reply
attached is the simplified file
i basically want it to connect the dots with a gradual slope - thank you!
compared.xlsx
Last edited by hluk; 07-07-2014 at 02:48 PM.
Fill in the blank cells in column B with
=NA()
Does that work?
Life's a spreadsheet, Excel!
Say thanks, Click *
Right click anywhere in the chart
On the pop-up menu, select "Select data..."
At the bottom left of the dialog box click "Hidden and empty cells"
On the dialog box select "Connect data points with line"
genius! thanks 6StringJazzer
To steal from Arthur C. Clarke, "Sufficiently advanced experience is indistinguishable from genius."
And we all know that experience is just another word for "made a lot of mistakes".....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks