Hello there,
I never used charts before and I have to admit that I am a little lost![]()
what I need is a single bar chart for every month in a year, so 12 bars...
I need grades on my bar... lets say that the bar is set at 200...
from 0-100, bar must be a certain color (objective not met)
from 100-150, that portion of bar another color (within objectives)
over 150, that portion of bar another color (exceeded objectives)
any help would be appreciated![]()
thanks,
Climbo
You are going to have to add 3 more columns. One for amount until objective, amount within objective, and amount exceeded. And then use a stacked bar graph to show them on top of each other.
I attached a sheet with the formulas and chart
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks