All articles with 'chart' Tag

Hui’s World ! – An Excel Project of Global Scale.

Published on Oct 23, 2018 in 3D Maps (non Power Maps), Excel Howtos, Huis, Posts by Hui
Hui’s World ! – An Excel Project of Global Scale.

Hui’s World is an advanced Excel animated chart displaying the Earth, Continents, Countries and States and key geographical features.
This post will describe how it works and how it was made.

Continue »

Conditional Formatting – Chart Data Labels

Published on Oct 9, 2017 in Charts and Graphs, Excel Howtos, hacks, Huis, Posts by Hui
Conditional Formatting – Chart Data Labels

Learn how to conditionally format Chart Data Labels without VBA

Continue »

Selective Chart Axis Formating

Selective Chart Axis Formating

A few weeks back, John asked a post question, “ How can I add a £ to the 80 on a Chart axis and leave the rest of the numbers plain numbers ? ”

Custom Number Formats, That’s How.

Continue »

Automating Repetitive Tasks

Automating Repetitive Tasks

Over at Newton Excel Bach I spotted the Dynamically Defined Dancing Pendulums. Doug had used Strand7 for the animation.

I thought I could do that in Excel and did.

This post demonstrates some of some basic VBA techniques used to simplify repetitive tasks used during the construction of the project.
For a full project description visit Excel Hero.com.

Continue »

Highlighting Data Points in Scatter and Line Charts

Published on Nov 11, 2010 in Charts and Graphs, Excel Howtos, Posts by Hui
Highlighting Data Points in Scatter and Line Charts

Introducing a method of allowing data points to be interactively highlighted in Excel Scatter / X-Y Charts and Line Charts.
You will see a lot of these style charts in various places where you want to highlight various aspects of the chart to your audience. It is a great technique for complex scientific and engineering charts where you may have hundreds or thousands of points.

Continue »

Is your (chart’s) underwear showing?

Published on Nov 14, 2008 in Charts and Graphs, Humor, Learn Excel
Is your (chart’s) underwear showing?

When I read Is your website’s underwear showing?, I couldn’t control the urge to write this one. So the big screaming friday question everyone… Is your chart’s underwear showing? What is my chart’s underwear? you may ask. My dear reader, it is the background color (that grayish shade excel adds by default). Also commonly known […]

Continue »