chart with only numbers

[Shahin Ghaffari]

Hi

In the attached file, I have a problem with Sereis Value of my chart because it shows all the blank cells and it causes a lengthy void space in the chart. on the other hand I have to choose all the column "E" as my series value because it will include data when I choose product from my scroll bar. How can I draw the chart with only numbers?

 

[rahulshewale1]

Hii @ Shahin


See if is ok ?


i used name Range.


Regard
Rahul shewale

 

[GraH - Guido]

Google dynamic chart series... It is also very well explained on Chandoo's blog.

 

[Shahin Ghaffari]

Hi

In the attached file, I have a problem with Sereis Value of my chart because it shows all the blank cells and it causes a lengthy void space in the chart. on the other hand I have to choose all the column "E" as my series value because it will include data when I choose product from my scroll bar. How can I draw the chart with only numbers?

Perfect Thank you

 

[Shahin Ghaffari]

Hii @ Shahin


See if is ok ?


i used name Range.


Regard
Rahul shewale

Thank you soooooooooooooooooooooo much