Area chart "base" seems to rise

Hi, I'm having more charting issues.

I plot a chart and make it an area chart. So far so good. When I move that chart to a different sheet, suddenly the base seems to rise. It starts at 0 where it should be, but then increases to almost 0.8. Does anyone know why this might be happening?

The workbook I have has a ton of personal data, so I'm going to post a screenshot. I realize this is generally frowned upon, but it shows the problem sufficiently.

Without being able to see the chart and its source data, I suspect it will be hard to say.

Yeah, I kind of figured that. Anyway, I figured out how to fix it, but I still don't understand what is going on behind the scenes to cause it. When I set the hidden and empty cells to Gaps, it changes the graph back to how I would expect it to look. If I leave it on Zero, it stays as it looks above in the screenshot.
If anyone can explain why this happens, I'd certainly apppreciate it.

Can you post example of data and chart

A bit delayed, but here is the example:

The chart object is corrupt for some reason.
Simply delete it and add a new chart, remember to fix the value axis to start at zero.

I tried deleting the graph and adding a new one, but the new one is exhibiting the same behavior. I am manipulating the graph by code, shown below. Don't be put off by the length, it is well commented.

Please Login or Register  to view this content.

Explanation of code:
Clear off previous graph data. Paste new graph data from results that have been exported onto a sheet from Access. Delete that sheet from Access. If any rows have no data, delete them. Set the graph header, gotten from cell 1,1 of the table. Check each column for data. If none is present, hide the column so it will not be graphed. The reason for this is the user is given an option to show up to 6 sets of data on the graph, and if they choose to do less than 6 but the columns are not hidden, the series markers will show up in the legend.

Thanks Andy

None of that code creates a chart.

I can not test it as I do not know what the arguments are.

The following, for me, creates a valid area chart on the Charts tab.

Please Login or Register  to view this content.

No, I'm not creating a chart. I have a chart set up and defined, and my code just changes the data that the chart will display. The arguments come in as the titles of the data charted - unless the user has not chosen to chart all 6 sets of data. In my posted example, strInv1 would have been "FAMC", strNR1 would have been "4.750%", strInv2 and strInv3 = "" and strNR2 and strNR3 = "0.000%".

Here is the workbook with a new chart correctly displayed. If the chart alters after running your code I would check to see the version of excel you have has all the service packs and updates applied.