Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way that I can create a bar chart similar to the one illustrated above? I want to show months on the X axis and minutes on the Y axis, and then 'stack' the minutes assigned to each category on top of one another in a single bar.
Hi,
See the attached QV application.
Use Month and Categaory as your dimension and minutes as your expression.
In the Style tab use Stacked as the Subtype.
Hope this helps
Regards
Mhatim
Hi,
See the attached QV application.
Use Month and Categaory as your dimension and minutes as your expression.
In the Style tab use Stacked as the Subtype.
Hope this helps
Regards
Mhatim
Thanks for the response - I didn't see the 'stacked' option for bar charts. I couldn't get your sample to run in QV because of the licensing but I followed your instructions and it works great.
Another question. The first set of data comes from a project management system, and shows a stacked view of the number of minutes spent on different projects by an individual in a month. Could I add a second bar that shows the number of minutes booked in the timesheet system we have? This wouldn't need to be stacked because it's just one number, I want to show a graphical comparison between the two.