Charting Examples
Excel Charting
techniques, solutions and examples
Add-In for applying Pattern fills to charts,
tables and
shapes in
PowerPoint 2007
Maintain plotarea ratios
A collection of tips compiled by guest poster
Ceri Williams
New Polar Plot add-in including examples file
VBA code to create square axis
VBA code to align plot area of 2 charts
A conditional line chart based on formula
Add-In for applying Pattern fills to charts and
shapes in
XL2007
User Defined Functions to calculate intersections
between lines and circles
Size pie charts plotarea
Highlight axis labels
Polar plots
Pie slice radius
Add data values to High-Low line
Colour xy scatter points
Automatically updating custom leader lines
Axis label alignment when charting positive and
negative bars
Creating bounding area within xy scatter
Use a pie chart as a data marker
Display pointer at end of axis
Display a cumulative total on a stacked column
chart
An step by step explanation on how to control the
Invert if Negative property
An explanation of how to delete a single legend
entry
Label last point in a chart using dummy data series
Dynamic scrolling through data
Alternate conditional dual category plot
Conditional dual category plot
An add-in to help create polar charts. Plus a
workbook which contains examples of polar plots
Various methods to create staggered axis labels
Various ways and chart types that can be used to
create a stepped line
Column chart that has variable width bars,
including a stacked style
Split a graphic into variable width sections
An alternative to zero or joined points
A pie chart that does not display zero values
Pie On Pie; Pie By Pie and Filled Doughnut chart
Column chart that has variable width bars
A work around for multiple images in a pie chart
A worked example of a clustered column chart with
a floating gap column
A worked example of a column chart with a break in
the value axis. Display data with large variance between min and max
values
A worked example of a conditional chart
A worked example of Side by Side stacked column
chart. Extended to handle xl97 category label limitations
A worked example of 2 sets of stacked bars with
different widths
Average line on chart. A collection of methods and
charts styles
Floating bar chart with the bars clustered
Thermometer style charts
Matrix of mini xy scatter plots
Stacked positive and negative bar chart with
series order maintained
Change the colour of a line as it passes above or
below a fixed datum line
Simulated 3d XY scatter
Mark the points of intersection between two lines
A speedo style chart
Last updated 24th October 2010
|
AJP
Excel Information
