• Home
  • About
  • Pages
    • Shortcodes
    • Columns
    • Typography
  • Contact
  • Follow Us
  • Become a Fan
  • Subscribe
logo
  • Blog
    • Archives
    • Best of
    • Subscribe
  • Newbies
  • Tutorials
    • Charts
    • Formulas
    • Tips and Tricks
    • Video Tutorials
    • Step-By-Step
  • Dashboards
  • Products
  • Subscribe
    • Email
    • RSS
    • Twitter
  • Videos
  • Products
  • Complete Pie Chart
  • postimage

    Shanghai License Plate Prices Part Deux

    A few months ago, i had the pleasure of traveling to Shanghai China and work in a nearby city of Suzhou.  Suzhou is known as the garden city and it is beautiful. While there, I saw an article in the ...
    May 20, 2012 No Comments

  • postimage

    How-to Put Percentage Labels on Top of a Stacked Column Chart

    There are times when you are creating your Excel Dashboard Design that you desire something that does not come naturally with the Excel Tools as designed.  In those times you will need to come up wit...
    May 15, 2012 No Comments

  • postimage

    FUN Chart (Happy Mother’s Day!)

    Recently I showed you one way that you can make Vertical Categories in an Excel Chart. (see How-to Make Categories for Vertical and Horizontal Axis in an Excel Chart) With that technique, you can crea...
    May 14, 2012 No Comments

  • postimage

    How-to Select Data Series in an Excel Chart when they are Un-selectable?

    When I first learned to make Excel charts, I was taught to select the chart and then select the data series with my mouse.  However, have you ever created a chart with so many data series in the grap...
    May 10, 2012 No Comments

  • postimage

    Case Study: Executive Dashboard Chart Creation – Follow-up

    The Problem In a recent post: “Case Study: Executive Dashboard Chart Creation” (http://www.exceldashboardtemplates.com/?p=1612) I presented some basic data that you may have in your company that y...
    May 08, 2012 No Comments

  • postimage

    How-to Make Categories for Vertical and Horizontal Axis in an Excel Chart

    There are times in your Excel dashboard career that your boss will ask you to create an Excel Chart with category values for both your horizontal axis as well as the vertical axis.  As you can see in...
    May 04, 2012 3 Comments

  • postimage

    Make a Pie Chart Rating for Excel Dashboard Chart Templates

    In a recent forum post, a dashboard user was asking how they can turn a decimal like 1.5 out of a 3.0 possible into a pie chart using Excel.  This specifics for the data range and chart design would...
    May 03, 2012 No Comments

  • postimage

    How-to Add Custom Labels that Dynamically Change in Excel Charts

    Have you ever wanted to have a different data point label in your Excel Chart than what is offered by the Standard Excel Dialog box choices? Well you can do that in Excel and not only can you do that...
    May 02, 2012 1 Comment

  • postimage

    Case Study: Executive Dashboard Chart Creation

    When building executive dasboards using Excel, you have to make the dashboard design choices that will assist your executives and the company in understanding the relationships of the data in a visual...
    Apr 30, 2012 No Comments

  • postimage

    How-to Plot Building Wall UR Value in an Excel XY Scatter Chart

    In an Excel Help Forum, an engineer wanted to know how to chart the following data: The data would need to be plotted like on the X and Y data points on the graph, however, there was a twist.  The da...
    Apr 25, 2012 No Comments

123›»

>

Popular Posts
  • Download a Free Target BMI Weight Tracker Spreadsheet
    Free Dashboard Template Download – BMI Weight Tracker
    Sep 06, 2011 - 8 Comments
  • How-to Hide Pie Slices when Value Equals Zero
    How-to Hide a Zero Pie Chart Slice or Stacked Column Chart Section
    Sep 12, 2011 - 5 Comments
  • Sample File of Excel Template Dashboard Tutorial Offset Function
    This is the Bomb: or How I came to love the Offset function
    Aug 23, 2011 - 5 Comments
  • Sample Displays of Excel Chart Dashboard Designs using Axis Groupings
    Dashboard Design Examples – Excel Chart X-Axis Grouping
    Sep 13, 2011 - 3 Comments
  • ChartAxisLabelsMillions_thumb.png
    How-to Format Chart Axis for Thousands or Millions
    Sep 23, 2011 - 3 Comments
Most Viewed
  • Line Feed in Excel Cell
    Excel Line Break/Hard Return ...

    6325 views

  • Download a Free Target BMI Weight Tracker Spreadsheet
    Free Dashboard Template Downl...

    4716 views

  • Sample Displays of Excel Chart Dashboard Designs using Axis Groupings
    Dashboard Design Examples - E...

    4526 views

  • The best place to learn how to make Excel Templates for Executive Dashboards
    Welcome to the New Microsoft ...

    4408 views

  • How-to Hide Pie Slices when Value Equals Zero
    How-to Hide a Zero Pie Chart ...

    3220 views

Recent Comments
  • admin on How-to Format Chart Axis for Thousands or Millions
  • Andrew on How-to Format Chart Axis for Thousands or Millions
  • admin on Free Dashboard Template Download – BMI Weight Tracker
  • παχυσαρκία on Free Dashboard Template Download – BMI Weight Tracker
  • admin on How-to Make Categories for Vertical and Horizontal Axis in an Excel Chart

About us

This is your one-stop-shop for everything Excel Dashboard related.

Tutorials, Free Templates, Formula and Chart Resouces will be provided so that you can develop your Executive Dashboard.

Visit often to learn how all the newest content to design and build your Excel Spreadsheet.

If you have any suggestions for content, please email me at Steve=True@exceldashboardtemplates.com.

Also, please sign up for my email list so that you are sure to get the most current Excel Dashboard Templates.

Subscribe to our feeds

Please subscribe to the FREE email subscription so that you get the latest posts from Excel Dashboard Templates

Quick Contact

Message Sent !

Categories

  • 3D Chart (1)
  • Axis Formating (4)
  • Banding Horizontal (3)
  • Bar Chart (7)
  • Cell References (10)
  • Chart (31)
  • Chart Title (2)
  • Column Chart (11)
  • Combined Chart (1)
  • Concatenate (1)
  • Conditional Chart (1)
  • Conditional Formatting (2)
  • Ctrl+~ (1)
  • Cylinder Chart (1)
  • Dashboard (29)
  • Dashboard Design (16)
  • Data (1)
  • Data Series (1)
  • Dynamic (16)
  • Engineering (1)
  • Excel Dashboard (3)
  • F3 (2)
  • Formatting (9)
  • Formulas (12)
  • Fun (5)
  • Function (1)
  • Funnel Chart (1)
  • Grouping (2)
  • Hide Zero Value (1)
  • HLookup (2)
  • Horizontal Cylinder Chart (1)
  • How-To (25)
  • Index (2)
  • Index/Match Formulas (2)
  • Label (1)
  • Left VLookup (2)
  • Legend (3)
  • Limit (1)
  • Line Chart (14)
  • Lookup Formulas (2)
  • Match (2)
  • Name (2)
  • Negative Values (1)
  • Pie Chart (3)
  • Pie Slice (2)
  • Pipeline Chart (1)
  • Practice (1)
  • Price-to-Earnings (P/E) (1)
  • Print Columns (1)
  • Print Dashboard (1)
  • Print Report (1)
  • Print Rows (1)
  • Print Titles (1)
  • Pyramid Chart (1)
  • Radar Chart (1)
  • Random (1)
  • Sample File (13)
  • Select (1)
  • Show Formulas (1)
  • Stacked Column (1)
  • Table (1)
  • Thermometer Chart (1)
  • Tips and Tricks (4)
  • Tornado Chart (1)
  • Trend Line (1)
  • Uncategorized (4)
  • Video Tutorial (19)
  • VLookup (2)
  • XY Chart (4)

Blogroll

  • Documentation
  • Plugins
  • Suggest Ideas
  • Support Forum
  • Themes
  • WordPress Blog
  • WordPress Planet

Subscribe

  • Subscribe

Tags

Absolute Reference Cell Reference Chart Column Chart Combination Chart Combo Chart Conditional Chart Dashboard Chart Dashboard Template Date Axis Define Name Dynamic Dynamic Chart Dynamic Excel Chart Dynamic Graph Excel Excel Chart Excel Dashboard Excel Dashboard Templates Excel Download Excel Formula Excel Graph Excel Line Chart Excel Line Graph Excel Sample Excel Spreadsheet F3 Format Formula Graph Labels Legend Line Chart Name Named Range Offset Formula Pie Chart Relative Reference Spreadsheet Stacked Bar Chart Stacked Column Chart Vertical Line Chart Xcel XY Chart XY Scatter
logo

Copywrite 2012 Exceldashboardtemplates.com

  • Contact
  • About