I was in and out for the webcast, but I did catch:
Format XY chart axis
Use picture as a data point
Change data source by changing chart data points
Adding a linked text box to a chart
Interpolate
Combine chart types
Multiple axis
Pivot table review
Pivot charts
It looked like there were approx. 110 people viewing. I thought Stephanie did a good job, here’s a few related links I found at her site:
Is there anything Excel can’t do?
Sizing Excel Charts for Word
Linking Text Boxes, Chart Titles, and Data Labels Dynamically to Data (Excel)
Show the Data’s Exact End Date on a Line Chart X-Axis (Excel)
January 21st, 2005 at 2:01 am
I think I was sitting in the 3rd row
Stephaine gave a slick presentation.
January 21st, 2005 at 2:10 am
Yeah i thought it was quite good, esp for the audience it was aimed at
I didn’t know excel 2003 charts (i don’t have it) could be used to move data points, (this is common is some maths/stats progs - statistica for example) … I can see this catching a lot of user out!
Linking text boxes might be more useful on a worksheet, but on a chart I would be inclined to use a blank range - again it may be easier for some user to use text boxes:
Interpolation concerned me a bit, it’s not good practice to use forecasting to fill missing data - well not unless that is you express intention, and extrapolation is not removing data from a data set - but that’s by the by. - i think this is one on those issues that might lead to misuse of something - it’s a hard line to toe, increasing usability, at the potential cost of decreasing validity
Overall quite good
January 21st, 2005 at 8:24 am
Not related to the content: If you turned your status to red, an actual human being would IM you to help resolve the problem, kudos. My audio quit for awhile, had to listen via phone for a bit.
January 21st, 2005 at 10:52 am
After i had downlaoded all the s/w, and logged in using IE and resigtered with . net password and jummped through a few more hopes, it worked very well, - to be fair. And it is very good that a real person came to help you, kudos indeed.