Help! Dynamic Charts

gheyman

Well-known Member
Joined
Nov 14, 2005
Messages
1,678
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

Well-known Member
Joined
Jul 8, 2002
Messages
11,044
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

New Member
Joined
Jul 13, 2005
Messages
35
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
 

Forum statistics

Threads
1,077,783
Messages
5,336,306
Members
399,074
Latest member
rlong98

Some videos you may like

This Week's Hot Topics

Top