Chart option "Connect data points with line" does not stick, how to lock this option in?

jombi

New Member
Joined
Apr 20, 2010
Messages
28
Hi all,
In Excel 2007, I have a chart where I've gone and set the "hidden and empty cells" option to "Connect data points with line". When I test this right as I set the option and save the workbook, it works fine. When the sheet is reopened later (after having some code populate new data from a database), the chart just shows the dots and they aren't connected. Some charts, however, do retain this option, others don't, I don't see any clear pattern as to which ones keep the option and which don't.

As far as what kind of chart this is...I don't know, so a sub-question would be "how do I tell what kind of chart was originally chosen when the chart was created?"...since the chart has existed for years and I didn't create it. I don't see a "Properties" option, and when I click "Change Chart Type", nothing is 'pre-selected' as what one might expect to show the current type.

Thanks for any help,
jombi
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Forum statistics

Threads
1,196,291
Messages
6,014,509
Members
441,825
Latest member
Lade

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top