making the chart disapear when there is no text

E

Erin Leva

I have to create a chart that gets updated daily. I need to create a formula
to calculate the % of our daily sales. What I wanted to do was put the
formula in in advance and then just enter in our daily sales so it would
automatically calculate the percentages. But when I do this The chart line
goes acros the month at zero. I have tried the IF formulas for if f5="",""
and it still occurs.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Turning off automatic calculation 0
Excel 2007 charts: want to avoid zero values 1
need some basic help 4
Charting a line and a bar on the same chart 1
How do I set up an automatic calculation by date in Excel? 0
Color Text in Charts 1
Is there a formula result that will not appear on a chart 2
Line graphs in Excel 2007 6

Top