Display Graph if data available only

[Surreyview]

Hello,
I have a spreadsheet, on the first tab is a large amount ofaccounts showing existing and new sales.

Each account has also has a separate tab within the samespreadsheet.

Where data (existing sales and new sales) is available onthe first tab, I would like a graph to automatically populate for the specificaccount on the specific account tab.
If data is not available, I do not want a graph topopulated.

Is this even possible to do in excel?
Thank you

 

[mole999]

If your Non Data is as #N/A then graphs can ignore those values, is that what you want