View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dot dot is offline
external usenet poster
 
Posts: 29
Default Graph Highest to Lowest.

I have data on my spreadsheet. (e.g) cells A1 to A 22 Candle Scents, Cells
B1 to B22 Candles Sold. I have created a bar chart referencing these cells
and it works, but the chart automatically put the numbers from highest to
lowest. I also don't want any candles sold < 3 to show up on the chart.
Right now all the candle scents show up on the chart no matter if any sold or
not. Can this be fixed.