I am creating a pie chart from cells that contain formula's, when the formula comes back with a blank value iit appears on the legend, is there anyway that i can get the legend to ignore the blank cells? Or is there anyway that I can get the Pie Chart to plot the series in numberical order so that I can just crop the bottom values. The latter would be a lot better solution as there are some cells that do give a value but have a value of 0.01 which can be dismissed.
Thanks in Advance
Alex
Bookmarks