I’m trying to build a stacked bar chart.
I currently have the report created with a bar chart in the report header. The chart has counts of events by hour. The hour axis is a formula (12am-1am, 1am-2am, and so on) and the data is the count of events. When you drill down through that chart you get a pie chart of the applications those events make up (application is another column in the table).
The person looking at the report would like the top chart to do stacked series by hour, only with the count of events divided in the bars by application. For some reason I try all kinds of stuff in the chart expert with y and x axis, setting to stacked chart and it won’t come out right…
Can anyone help?
flyefisher (BOB member since 2006-03-28)