All articles with 'chart' Tag
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.
Conditional Formatting – Chart Data Labels
Learn how to conditionally format Chart Data Labels without VBAContinue »
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
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | RSS
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.
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.
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 »