Fast and Fabulous Webcast
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)
Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
Get answers right away at our AE Excel Support Forums!
I think I was sitting in the 3rd row
Stephaine gave a slick presentation.
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
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.
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.