ProcessTrends.Com
Home
Chart Gallery
Video Tutorials
Trend Analysis
Using R
Data Visualization
 Global Warming
Map Excel Data with Google Earth
Chart Doctor
Advanced Chart Techniques
Links
What's New
Downloads
  About      
 Search Site RSS
   04/4/2008 4:30 PM

 

Advanced Chart Techniques  

Techniques I Use to Produce Enhanced Excel Data Visualization Charts
Techniques Organized in 6 Suggested Learning Steps

1
Moving Beyond Chart Wizard
2
Transform Axes
Dummy Axis Series
3
Making Charts Dynamic, Interactive
4
Controlling Charts with VBA
5
Dashboards
6
 Process Data
Toolkit
Excel Chart Links - Workbook with 150 links to Excel charting articles and downloads
Step 1: Moving Beyond the Chart Wizard Chart Toolbar Use Chart Menu to select, format all components of your chart
Effective Charts Step by step guidelines to converting Excel's default charts into professional looking charts
Excel Data How to organize, manipulate your data to improve your charts
Data Scrubbing Downloadable workbook  includes 7 VBA procedures to handle a wide range of data scrubbing situations often found in working with process data.
Missing Data Handling missing data is one of the most common questions on the Excel Chart User Forum
Handling Dates in Excel XY charts I use XY charts almost exclusively for my trend charts. This post shows how to format dates and times so that XY charts look just like Time Series charts.
Adding Lines to Chart Add Horizontal Line
Add Vertical Line
Using Error Bars
       o Floating Bar Chart

       o Step Chart
Adding Text to Chart Dynamic Chart Title  
Labeling Points on XY Charts
Must Have Excel Chart Add-Ins J-Walk Chart Tools Add-in
AppsPro's XY Chart Labeler

JuiceAnalytics Chart Cleaner
Step 2: Custom Axes (aka Dummy Axis Series) Overview - Custom X and Y Axes Custom Axis Tutorial
Custom Axis and Gridlines Dot Plots
Day of Year (DOY) Trend Chart

Flexible Log Scale
Step Chart
Transforming Axis To Show What You Want Panel Charts
Step 3: Making Your Charts Dynamic, Interactive Dynamic Charts Dynamic Range Names
Highlight Min & Max Values - XY Chart
Dynamic Chart Title
Plot User Selected Number of Days
Chart Animation
Select Start and End Dates for Trend Chart
Interactive Charts Interactive Trend Charts - Checkboxes
Trend Chart Animation
Interactive Trend Chart - Moving Average
Interactive Trend Chart - Scroll and Data Series Check Box
Select Start and End Dates for Trend Chart
Step 4: Chart - VBA Use VBA to automate your charting process. Chart Object Information
Make List of Charts in Worksheet
Freeze Text Font Size
Size & Align Charts
Select Start and End Dates for Trend Chart
Chart in A Cell
Setting Cell Size 
Process Data Toolkit
Step 5 Dashboards

 

Techniques to help make Excel based dashboards Excel's Camera Tool
Chart in A Cell
Setting Cell Size 
Video
Step 6 Process Data Toolkit