Hi,
I'm sure this has been asked and answered many times here, but a quick scan didn't turn up the answer I'm looking for..
I want to create a simple 3D bar graph where one bar is "Sales Goal" and the bar next to it is Actual sales that shows as percentage attained. Conversely, I'd settle for something like those fundraising thermometers where the top line is $100,000 and it gets colored in and fills up as funds come in. I'm basically just looking for a visual aid to represent how close we are to hitting our sales goal
Simply put, if cell B6 is sales goal and cell B7 is sales to date, I know how to create a bar graph showing those two data points with their accompanying legends. But if I use the 3D chart in percentages, both columns in the graph will show 100%. I need to take B7 and divide it by B6 to get a percentage. I can do that in a separate cell (by formatting to percentage), but ideally, I'd like to perform this calculation in the chart so that's not necessary to have this extra cell cluttering up the spreadsheet and the bar with the legend "actual sales" just fills up next to "Sales Goal" with the corresponding percentage reached to date
Can anyone help me with this?
Bookmarks