[VB6] Color surface and scatter charts with nice color maps
Dear all,
As heavy user of Excel 2007, I'm happy with the quick analysis available through pivot table. Unfortunately the default layout for the contour graph and the need for a regular grid reduce productivity.
So I created a macro call ColorThirdAxis (available in a separate tab in the example excel file) to improve that status. So the current macro works on surface and wireframe charts and on XYscatter charts. For the contour chart, you'll need to simply pick up a colormap in the user form. Then the macro will color categories following the map (for top view contours the bands will be flattened).
For scatter plots, in addition to the colormap, you'll have to pick a range of values defining the point colors. And you can set manually the bounds of the data range for colormap interpolation.
The picture shows a possible result of the macro on the example file.
I hope you'll find it useful.
Notes:
1. The macro uses JsonBag (search on this forum for it) to read colormaps.
2. Credits for the colormap go to the Palettable Python project.
Last edited by freudericc; Nov 19th, 2015 at 01:53 AM.
Reason: Update macro (Correction minor bugs)
Re: [VB6] Color surface and scatter charts with nice color maps
Originally Posted by freudericc
Dear all,
As heavy user of Excel 2007, I'm happy with the quick analysis available through pivot table. Unfortunately the default layout for the contour graph and the need for a regular grid reduce productivity.
So I created a macro call ColorThirdAxis (available in a separate tab in the example excel file) to improve that status. So the current macro works on surface and wireframe charts and on XYscatter charts. For the contour chart, you'll need to simply pick up a colormap in the user form. Then the macro will color categories following the map (for top view contours the bands will be flattened).
For scatter plots, in addition to the colormap, you'll have to pick a range of values defining the point colors. And you can set manually the bounds of the data range for colormap interpolation.
The picture shows a possible result of the macro on the example file.
I hope you'll find it useful.
Notes:
1. The macro uses JsonBag (search on this forum for it) to read colormaps.
2. Credits for the colormap go to the Palettable Python project.
Hi, any people have this file of Contour Excel to share?
ColorThirdAxis_v1.1.zip have broken link !
Re: [VB6] Color surface and scatter charts with nice color maps
Originally Posted by DracullSoft
Adding the broken zip
ColorThirdAxis_v1.1.zip
Hi, someone have this sample file, please
the file not downloading, bug in download process.
please, extract the zip and make new file and re-upload the file.
thank you very mutch.