Some Charting Tools for Excel
This page demonstrates the charting features of Microsoft Excel. The use of VBA to control chart objects is explored.
This is a small collection of Excel workbooks which provide charting tips and utilities using VBA macros. All the files are provided as samples, whilst some of these are useful in their own right, they are meant to be demonstrations of VBA code which you can edit for your own use.
Most files are compressed using .zip. The Size column gives an indication of file size in Kb.
-
BCG Matrix [12.04 KB] [2020-08-28] -
Calendar [14.82 KB] [2020-08-28]
-
ChartFormatLines [13.56 KB] [2020-08-28]
-
ChartPoints [8.94 KB] [2020-08-28]
-
CondFmt [20.92 KB] [2020-08-28]
-
ConvertDataColumntoRow [10.45 KB] [2020-08-28]
-
CustomReplace [7.22 KB] [2020-08-28]
-
DataTab [5.67 KB] [2020-08-28]
-
EFutil [10.59 KB] [2020-08-28]
-
Henderson [12.82 KB] [2020-08-28]
-
Intercepts [3.69 KB] [2020-08-28]
-
MakeGif [3.64 KB] [2020-08-28]
-
MapEurope [205.89 KB] [2020-08-28]
-
MapUSA [106.87 KB] [2020-08-28]
-
Multiple Chart Builder [20.62 KB] [2020-08-28]
-
PsychChart [47.73 KB] [2020-08-28]
-
Rotate [7.38 KB] [2020-08-28]
-
SWOT [8.67 KB] [2020-08-28]
-
Speedo [5.81 KB] [2020-08-28]
-
StockQuotes [3.23 KB] [2020-08-28]
-
Ternary Plot [28.49 KB] [2020-10-10] -
VaryColourAndWeight [36.91 KB] [2020-08-28]
-
ViewSelector [9.32 KB] [2020-08-28]
-
Waterfall [19.18 KB] [2020-08-28]
-
WindRose [16.52 KB] [2020-08-28]
-
ZoomChart [12.12 KB] [2020-08-28]