Data line does not show (only sometimes) on macro updated scatter plot

[JackRose]

I have a two list boxes that select a location and a person, I've written a macro that then updates the chart's range when the list box is altered, so that you can easly select the data to view and it pops up.

Works great except sometimes the data just doesn't show up. The chart x-axis values are updated, so is the title, and when I go to select data it says that the correct range is selected, but I'm still left with a blank scatter plot. Then when I change the graph type the data apears.

Seems to be an issue for only some of the data sets, the ones that don't work always don't work.

Anyone ever had this problem? Below is the code attached to the list boxes.

Thanks for any help,
Jack Rose

Please Login or Register  to view this content.

[Richard Buttrey]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

The usual reason is chart data in hidden rows or columns. There is a chart setting which can be ticked to overcome this.

[JackRose]

I don't think the data is hidden, I put it there, so unless it did it automatically it shouldn't be hidden. Is the chart setting you're talking about found under [Select data>Hidden and empty cells>Show hidden and empty cells ]? Because that didn't help.

Thanks, Jack

[Andy Pope]

If the issue is only with some data sets then it is unlikely to be the code but rather the data and or chart.
Can you post example workbook that illustrates the problem