creating a chart excel 2010 problem

[John Caines]

Hello All.
I have a spreadsheet (Excel workbook 2010).
I have my main data that I want to chart on a tab called "Daily Targets"
The chart is on a tab "Equity Graph"

In column AG (From AG25:AG263) will be a running balance that I would like to plot on the chart.

Its a daily running total, so it can go up or down in value.
The starting balance is in Cell J23 (Currently £15,000)
So, at present, I have 5 days of data in column AG
AG24=£15,103
AG25=315,314
AG26=£15,424
AG27=£15668.56
AG28=£15,788.56

Could someone please help me with the formula to display this in my chart.
The problem I'm having is it is showing all 240 points of data on the chart,, IE the other 235 points as ZERO,, when seeing as I have no data in the other 235 AG cells,, I would like these hidden,, IE not displayed on the chart.

Been playing about with it,, just can't seem to do it.

Hope someone can help me with this.
Maybe a defined name formula is needed?
Not sure.
Charting isn't my thing it seems!
Many thanks anyway.
Best regards
John Caines

 

[John Caines]

Just To Add
At present I have for my actual results of the chart:
Series Name:
="Actual Results"
Series Values:
=('Daily Targets'!$J$23,'Daily Targets'!$AG$25:$AG$263)



hope this helps,,, just don't want the cells in Column AG with no values to show nothing in the chart,,, I'm sure its the formula,, I think