Improve Your Excel.com
Everything you need to improve your Excel in one place!
Home Categories Tips By Email Search Contact Us Other Links Your Questions Answered

Online Training

Excel Charts

Excel Charts are visually appealing and make it easy for users to see comparisons, patterns, and trends in data.

  • Add graphics to your page header


  • Advanced Gantt Charts in Microsoft Excel


  • Another column chart with varying width bars


  • Apply Fill Color Between Lines in a Chart (TechTrax Article)


  • Automatic removal of zero values in pie chart


  • Average Lines


  • Axis Pointer


  • Black and White Blues


  • Bounding areas


  • Box and Whisker Plots - Upgraded Utility


  • Business Diagrams & Org Charts


  • Change your Excel chart's number formats


  • Changing Chart Type


  • Charting Tips


  • Charting with Time on the X-axis


  • Cluster column chart with floating gap


  • Colorizing Charts


  • Column chart with varying width bars


  • Complex Intersections


  • Conditional Line


  • Consolidate Text Data for Charting


  • Create a Chart with 1 Keystroke


  • Create a combo box for users' data in an Excel chart


  • Create a Time Line


  • Create an Excel chart that automatically updates with new data


  • Create Sparklines - Tiny, Word-sized Charts in Excel with SparkMaker


  • Creating a Chart


  • Creating a linked picture of a range


  • Creating a non-graphic chart directly in a range


  • Creating a thermometer style chart


  • Creating a transparent chart series


  • Creating combination charts


  • Custom leader lines


  • Delete single legend entry


  • Demonstrate fractions with a pie chart


  • Different width stacked bars


  • Display multiple charts on a single Chart sheet


  • Display Total on stacked column


  • Displaying a value in an AutoShape


  • Dividing a graphic into sections


  • Drawing with Excel - grid paper


  • Expand the Chart Range


  • Extending with Data Points


  • Format cells to display in thousands


  • Gantt Chart with Conditional Formatting


  • Handle missing data in a line chart


  • High-Low values


  • Histogram - Create a Dual Sided Histogram in Excel


  • How to Add a Series to an XY (Scatter) Chart with a Second X-Axis in Excel 2000


  • How to Add Text to the X or Y Axis on a Chart


  • How to Add Text to the X-Axis or Y-Axis on a Chart in Excel 2000


  • How to Add Totals to a Stacked Column Chart in Excel 2000


  • How to Change the Chart Type of a Series in a Combination Chart in Excel 2000


  • How to Create a Column Chart with Two Y-Axes in Excel 2000


  • How to Create a Normal Chart from a PivotTable in Excel 2000


  • How to Rename a Chart by Using the Name Box in Excel 2000


  • How to Use Lotus 1-2-3 Commands to Attach Text Data Labels to a Chart in Excel 2000


  • How to Use the Chart Wizard in Excel 2000


  • In Cell Charting with Worksheet Formulas


  • In-cell Column Chart


  • Invert if Negative


  • Keep embedded charts off your worksheet printouts in Excel


  • Label high-low line with values


  • Labeling last point


  • Layouts for column charts


  • Pareto Plotter


  • Positive/negative axis labels on a bar chart


  • Rotating text with an AutoShape


  • Saving a chart as a GIF file


  • Scrolling data chart


  • Side by Side stacked columns


  • SmartArt Graphics in Excel 2007


  • Speedometer Charts in Excel


  • Spotlight Chart


  • Stacked Pos/Neg bar


  • Staggered Axis labels


  • Step Charts in Microsoft Excel


  • Step Line charts


  • Stock Charts and Other Line Chart Tricks


  • Summarize Data using a Pivot Charts


  • Survey Pivot Charts


  • The Quick XY Charts Utility


  • Thermometer Charts


  • Tile Chart


  • Tip. Line chart marker variations


  • Tips for the 'Perfect Chart'


  • Track Progress Towards a Goal


  • Track Student Reading Progress with a Dynamic Chart


  • Unlink a chart series from its data range


  • Update charts automatically when you enter new data


  • Use an Arrow to Indicate Special Points


  • Use these tricks to add pizzazz to your 3-D Excel charts


  • XL: How to Add New Data to a Data Map Chart


  • XL: How to Add Totals to a Stacked Column Chart


  • XL: How to Change Chart Type of a Series in Combination Chart


  • XL: How to Create a Bell Curve Chart


  • XL: How to Create a Biorhythm Chart


  • XL: How to Create a Chart with Discontiguous Ranges


  • XL: How to Create a Column Chart with Two Y Axe


  • XL: How to Create a Gantt Chart Using Hours as the Scale


  • XL: How to Create a Gantt Chart Using Hours as the Scale


  • XL: How to Create a Spiral Chart


  • XL: How to Create a User-Defined Chart Format


  • XL: How to Create a User-Defined Chart Format


  • XL: How to Programmatically Print All Embedded Charts on a Worksheet


  • XL2000: How to Break Links Between a Chart and a Worksheet


  • XL2000: How to Change the Taper Style for All Series in a Chart


  • XL2000: How to Create a Chart with Non-Contiguous Ranges


  • XL2000: How to Programmatically Create a Chart Without Selecting a Range of Cells


  • XL2000: How to Trap Events for an Embedded Chart


  • XL2000: How to Use the ApplyCustomType Method to Format Charts


  • XY Area Chart - Fill Below an XY Series


  • XY Area Chart - Fill Between XY Series



  • Want more tips? Subscribe to our Free Newsletter today and we will send them to you.

    Most Popular Categories |Bar_Charts |Charts |Pie_Charts |Excel Counting |Excel Filters |Pivot_Tables |Excel_Keyboard_Shortcuts |Conditional_Formating |VLookup |Games |Names_and_ranges |VBA_Examples |Macros