Help! Dynamic Charts

[gheyman]

I have pulled a bunch of info on Dynamic Charts but they are almost exclusively a two column data source with the monthly or dates down the first column and data (numbers) down a second column. I need a dynamic chart that has Department down the first column, Months across the top row. I am charting monthly hour spent by each department. What I need the dynamic chart to do is to allow the user to choose how far down the first column (the department to chart (less say the chart only Shipping thru Purchasing).

Is this possible

Feb Mar Apr
Shipping 102 105 108
Accounting 156 205 182
Purchasing 198 212 205
Quality 107 101 102
Engineering 56 64 71

 

[GlennUK]

Try using a drop-down with the list of departments for the user to choose the last row for charting, and use a dynamically defined name to create the reference for charting.

 

[asgourlay]

Possible solution - Pivot Tables

Simplest way I can think to solve this is to rearrange the data into three colums with Departments in 1, Month in 2, Hours in 3. Then use excels pivot table/chart function this will enable a chart with selectable ranges.

I treid this with Month in Series Fields Department in Category fields and Time in the Data Items (formatted to Sum instead of the default count)

R