Results 1 to 7 of 7

Thread: [VB6] Color surface and scatter charts with nice color maps

  1. #1

    Thread Starter
    New Member
    Join Date
    Nov 2015
    Posts
    1

    [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.
    Attached Images Attached Images  
    Attached Files Attached Files
    Last edited by freudericc; Nov 19th, 2015 at 01:53 AM. Reason: Update macro (Correction minor bugs)

  2. #2
    Member
    Join Date
    Sep 2016
    Posts
    53

    Re: [VB6] Color surface and scatter charts with nice color maps

    can't download file,please help,thx

  3. #3
    Lively Member
    Join Date
    Jun 2016
    Posts
    106

    Re: [VB6] Color surface and scatter charts with nice color maps

    Quote Originally Posted by freudericc View Post
    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 !

  4. #4
    Member
    Join Date
    Sep 2016
    Posts
    53

    Re: [VB6] Color surface and scatter charts with nice color maps

    if you want to use these chart , you can google "ChartDirector ChartViewer"

  5. #5
    Lively Member
    Join Date
    Aug 2008
    Location
    Denmark
    Posts
    85

    Re: [VB6] Color surface and scatter charts with nice color maps

    Adding the broken zip
    Attached Files Attached Files

  6. #6
    Lively Member
    Join Date
    Jun 2016
    Posts
    106

    Re: [VB6] Color surface and scatter charts with nice color maps

    Quote Originally Posted by DracullSoft View Post
    Adding the broken zip
    ColorThirdAxis_v1.1.zip
    Hi, not downloading, please atach new and put a link to external disk please, please !

  7. #7
    Lively Member
    Join Date
    Jun 2016
    Posts
    106

    Re: [VB6] Color surface and scatter charts with nice color maps

    Quote Originally Posted by DracullSoft View Post
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width