binding points in a line chart when having empty cells

K

Ksenija

Hi,
I need to make a linechart, but I do not have values in every cell in
columns I am using. I would like the values I have to be binded together. Now
they are binded if there are no emty cells between 2 points.

I can not put in values in the empty cells, they have to be empty..
 
A

Andy Pope

Hi,

You can select the chart and use menus Tool > Options > Chart > Plot empty
cells: Interpolated.

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

Word macro that can call cells out of Excel for a find and replace 0
Creating a Chart on form from selected data in query. 0
Search for empty cells and move cells next to 10
VBA Coding Help for Beginner 0
Trendlines: When They Will Be Generated, And When They Will Not BeFor A Scatter Chart 0
Autonumber field in Excel that behaves the same as Access 0
Suppres Zero or empty Cell value in a line graph 1
XY Charts - not plotting zero or #N/A Points 2

Top