Dynamic chart issue.

All,

I have a simple 4 column table which I need the contents dynamically plotted.

All columns will be dynamic, but I'm only really interested in plotting A/B and A/C.

The issue is that I've hard coded a summing equation into these columns which always fails under the last row of data, and I cannot seem to suss out how to incorpreat this into my charts......i.e. make them dynamic without plotting the last row with the summing equations in!!!

Whilst I have managed to plot these (see attachment), my series equations are clearly wrong.

Please could someone direct me on where Im going wrong here especialy as also I'm losing x axis data points every now and again too!!


Thanks for looking.

Skyping