When creating a graph, I have the following problem:
My graph shows the values for the individual months. However, for the last month (December) the value is still 0 since the month is not over. The value is calculated by multiplying the number of items with the price. Since no items will be registered as long as the month is not over, the value will aways be 0 (as long as the month is not over).
If I make my graph, including the month of December, there is a sharp decline in December (zero). Of course i can exclude the month of december in my range, but that is a waste of time as I will have to include it again at the end of December.
Is there a way to tell Excel not to display a zero in a graph? Or an alternative?
Hi thorgal67,
Instead of zero could you display a blank for values that are zero? This might solve your problem.
One test is worth a thousand opinions.
Click the * below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks