Toni, post some sample data, and describe the
chart that you want.
OK, I uploaded a Word document with the data and a .gif of what I want the chart to look like. If you or anyone else could go take a look at it and tell me how to make the chart in Excel, I'd owe you a kidney or something! Here is the file: http://www.geocities.com/darkladykatja/chart.doc
Thanks,
Toni
Toni, I looked at your sample data. Here's a
simplier data set that illustrates my approach...
Let's assume that A1:B5 contains...
"",Album
A,05:43
B,06:03
C,05:28
D,08:10
I formatted column B using the elapsed time
format... [mm]:ss
The average time values should be entered as
0:5:43, 0:6:3, etc.
The chart itself is created by selecting cells
A1:B5, choosing the Insert | Chart... menu commmand,
choosing the 1st Column Chart subtype at Step 1 of
4, pressing the "Series in" Rows radio button at
Step 2 of 4 and then pressing [ Finish ].
Now for some refinements...
Right-click the Y-axis and choose the Format Axis...
command, click on the Scale tab, enter the value,
.0010416667, into the "Major unit" field, and press
[ OK ]. This sets the Y-axis to 1 1/2 minute
increments.
Finally, right-click on any of the displayed chart
columns, choose the Format Data Series... command,
click the Options tab, change the "Gap width"
to 0, and press [ OK ]. Now the only thing left
to do is add your Chart title.
Let me know if you have additional questions.
That really helped!!! Thank you sooooo much!
Toni