sparkline refresh

[Imran Azam]

Hi guys

i have the data below

[TABLE="width: 500"]
<tbody>[TR]
[TD]name[/TD]
[TD]jan[/TD]
[TD]feb[/TD]
[TD]march[/TD]
[TD]april[/TD]
[TD]may[/TD]
[TD]jun[/TD]
[/TR]
[TR]
[TD]jack[/TD]
[TD]10[/TD]
[TD]15[/TD]
[TD]17[/TD]
[TD]17[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I have created a sparkline based on this, I dont have the data for may and june as of yet.

Can i set this sparkline up so it automatically updates when may and jun data comes?

at the moment if i include may and june in the range it shows it 0 in the sparkling

can this be done ?

thanks

 

[mole999]

Re: sparkline refresh help

Can you put in #N/A for a normal chart that shouldn't then model

 

[Imran Azam]

Re: sparkline refresh help

thank you i will try this

 

[Imran Azam]

Re: sparkline refresh help

this doesn't seem to work is there any other way?