| |
| Excel Pivot Charts
Posted in MS Excel > Charts and Graphs by tutorialgrub on Jul 14, 2011
A pivot chart in Excel is the visual representation of your pivot table. |
| |
| Excel Charts
Posted in MS Excel > Charts and Graphs by tutorialgrub on Jul 09, 2011
A simple Excel chart can say more than a sheet full of numbers. |
| |
| Excel Sparklines
Posted in MS Excel > Charts and Graphs by tutorialgrub on Jun 23, 2011
Excel Sparklines are graphs that fit in one cell and give you information about the data. |
| |
| How to use a Scroll Bar in Excel
Posted in MS Excel > Charts and Graphs by tutorialgrub on Jun 13, 2011
How to use a scroll bar in Excel to create a scrollable list. Great for dashboards. |
| |
| How To Change The Chart Point Style In Excel
Posted in MS Excel > Charts and Graphs by tutorialgrub on May 21, 2011
This video tutorial shows how to change the chart point style in Excel. |
| |
| Better Charts in Excel using Photoshop
Posted in MS Excel > Charts and Graphs by tutorialgrub on May 14, 2011
When creating charts in Excel, you are limited to generic colors and themes. However, by exporting the graph into Photoshop, you can easily transform a once boring graph into a stunning masterpiece. |
| |
| Create a Thermometer Chart in Excel
Posted in MS Excel > Charts and Graphs by tutorialgrub on Apr 26, 2011
Thermometer charts in Excel are great for comparing actual figures against a target. This article looks at how to create a thermometer chart. |
| |
| Using Sparklines in Excel 2010
Posted in MS Excel > Charts and Graphs by tutorialgrub on Apr 26, 2011
Use Sparklines in Excel 2010 as a visualisation tool to see data trends at a glance. Sparklines are mini charts inserted inside cells of Excel 2010. |
| |
| Scatter Plot Graphs with Trendline
Posted in MS Excel > Charts and Graphs by tutorialgrub on Apr 21, 2011
Scatter plots are used to see the trend of the data set as a whole instead of the sequential pattern of the data. |
| |
| How to make True Time Scale Line Chart Using Scatter Graph
Posted in MS Excel > Charts and Graphs by tutorialgrub on Apr 15, 2011
Adjusting time scale on x-axis in standard line chart could be a headache. It is kind of a trial and error process to make the time scale fit in, distribute the labels properly and last date being shown correctly at the end of x-axis. |
1 2 >> |
