I have a worksheet on the last page of my workbook that keeps track of all the hours worked in different categories, and it has a place for the budget hours that should have been worked. I would like to keep a bar graph on the last page, comparing budget to actual. Most importantly, I would only like those categories that actually have entries made on them to show up on the chart, in order to cut down on clutter and make it easier to read. Any suggestions on how to have the entire data set selected, but to just get the ones with numbers to show up on the graph? Any suggestions on how to make an actual vs. budget bar graph look really professional and easy to read?
Bookmarks