sparkline refresh

[Imran Azam]

Hi guys

i have the data below

name	jan	feb	march	april	may	jun
jack	10	15	17	17

<tbody>
</tbody>

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?