Advanced Excel Graph Techniques
EXAMPLES
CONTENT |
SPREADSHEET |
INSTRUCTIONS | |
1 | Graph Types | Graph Types.xls | GraphTypes.doc |
2 | Using Pictures in Bar and Column Graphs | Pictures.xls | Pictures.doc |
3 | Changing the background of the print area | Background.xls | Background.doc |
4 | Change the axis values | Change Axis.xls | Change Axis.doc |
5 | Changing the worksheet name | PageTitles.xls | titles_on_page.doc |
6 | Normalised Data | Normal.xls | |
7 | Box Plots | box plot.xls | BoxPlots.doc |
8 | Selecting Non Adjacent Data | select non adjacent data.xls | Selecting Non Adjacent Columns.doc |
9 | Sliders | slider.xls | Sliders.doc |
10 | Trendlines | Trendline.xls | Trendlines.doc |
11 | Visual Basic for Applications -Example | EasyGraph.xls |
Dennis Fitzgerald © 2002