HELP! Chart Zero Values

  • Thread starter Thread starter nic1975
  • Start date Start date
N

nic1975

Hi,
I'm new to this forum...I hope someone can help. I have just become
trainee Office Trainer, and a delegate has asked me a question that
can't immediately help her with. She has a job interview thi
afternoon and has been given some Excel tasks to do.
She has been asked to create a scatter chart using 2 columns of data i
the spreadsheet. How do you get the chart to not display the data i
either the x or y axis data is null?
I know you can get the chart to not display the values if both x and
are zero, but what if just one of the axis is zero?
If anyone can help me with this within the next hour or so, I would b
eternally grateful.
:confused
 
Click on my screen name and then select "Threads started by that name".
I asked this question a few weeks ago.

Frank was kind enough to help, and a few other guys tacked on som
stuff that sounds like it would for scatter charts.

It sound like it might be complicated
 
Back
Top