Chart Showing Estimate an Actuals
Looking to make a simple bar chart showing the totals of actuals and estimates. Table is attached. I just can't figure out how to do. I did have a column I deleted that was "Budget Type" that has ...
Forum Discussion
Definitely the latter. Ideally, two columns for each Fiscal year, showing a sum of actuals in one, estimates in the other. (I can then dynamic filter by year, if I want to simply the chart.)
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------
Easy enough then - you would make a chart report of type 'bar' and then for your x-axis you would include the 'Year' field that you want to report on, then for your y-values you would first put estimated and then add another y-value an include the actuals.
------------------------------
Chayce Duncan
------------------------------
There is the kicker then. How do I add a second value to the Y axis? I don't see that as an option anywhere.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------Good grief, Tony! Actually moving your mouse over the section you need to edit is a miraculous thing. Yes, now I see the +/- at the end of a entry where I can add multiple values. This opens up the entire world of possibilities for charting/reporting I have been looking for. Geesh, Louise! What a moron. I guess "talking" it out helps. Thanks, Chayce. Such a simple answer, but you just even stating the obvious made me reexamine what I thought I knew/didn't know.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------It' hard to send a screenshot - but in the section for the y-axis you will pick the first value you want - then hover over that it or somewhere right around it and there should be a green + button that appears to add a new row.
------------------------------
Chayce Duncan
------------------------------