Results 1 to 2 of 2
2002-12-05, 19:07 #1
- Join Date
- Jun 2001
- New York, New York, Lebanon
- Thanked 1 Time in 1 Post
Charting Advice (Excel 97 to 2002)
For the Excel Forum
<img src=/S/hello.gif border=0 alt=hello width=25 height=29> Loungers
Please let me describe the situation and then the question...
I have a set of events that happen on a daily basis, call them events A through H.
I chart these events per day of the month, over a 12 months rotating period.
I have a column chart where for each day, a column will represent an event, and how many ever events happen that day, well that is how many columns I will have.
I have the rows 2 to 367 represent the days of the Months, and then columns B through I represent the events. Column A will have the dates, and Row 1 will have the Column Headers.
So each cell in the range B2 to I367 will have an event in it, or it will represent an event. The data is coming from an AS-400 mid mainframe using ADO and VBA to add the values up and set them into a worksheet where the data range get further manipulated.
Now comes the problem. A request has come up and it is going to require a radical change in the above design. <img src=/S/boxedin.gif border=0 alt=boxedin width=25 height=20>
They want to see sub events within each daily event. So if we are talking about event A, which is a cumulative number, now they want to see what that cumulative number is made up of. So if Event A happens on Day 1 then it will have a value of say 6, and the 6 is 0.5 + 4 + 0.75.
I am, now, to chart the 0.5 the 4 and the 0.75 in what I am thinking of as a Stacked Chart for each day.
How do I rearrange the data so that I can make this as painless as possible? I do understand that Excel does some funky stuff with Stacked charts, such that the first stack and the second stack may not be consecutive or in adjacent cells
Any one has any ideas? Any better approaches?
<img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15> in Advance.
Wassim<img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>
2002-12-05, 20:37 #2
- Join Date
- Jul 2002
- Pittsburgh, Pennsylvania, USA
- Thanked 342 Times in 335 Posts
Re: Charting Advice (Excel 97 to 2002)
If I understand completely, It sounds like you will either:
Need multiple subgroups of A-H (the number of subgroups will equal the number of subevents you want to plot), Cols A-H, I-P, Q-X, etc
Cols A-E subevents 1-5 (event "A")
Cols F-K sub events 1-5 (event "B")
Multiple events per day in groups
Row 2 - 367 total (not plotted)
Row 368 - 733 subevent
Row 733-1098 subevent2
Multiple lines per day
row 2-6 day1 event 1-5
rows 7-11 day2 event 1-5 etc
Or each sub event on a separate sheet