NanoCharts milestone release v0.51

October 26, 2007 Jesper DevLog, Excel Go to comment

Keywords: Nanocharts, sparklines, VBA, in-cell graphing

Version: Tested on Excel 2003.

Download: NanoCharts public beta 0.51 (downloaded 1316 times)

Just a quick heads-up about the latest version of the Nanocharts add-in. I have added some options such as highlighting the last data point, display the last data value and showing the x-axis. The user can also select and customize the colors used for the Nanocharts.

Nanocharts, sparklines, VBA, in-cell graphing

The data orientation is not yet implemented, nor can multiple charts be inserted at once, but these functions will make it into the next release.

Nanocharts, sparklines, VBA, in-cell graphing

A sample output can be seen in the image below.

Nanocharts, sparklines, VBA, in-cell graphing

The Nanocharts are by default set to include hidden cells, so by untilizing this and hiding columns you can make extremely readable report summaries, but that still contain the same information density:

Nanocharts, sparklines, VBA, in-cell graphing

Please don’t hesitate to leave feedback, requests and suggestions for the coming development of NanoCharts. See you soon!

Download: NanoCharts public beta 0.51 (downloaded 1316 times)

Popularity: 10% [?]

8 Responses to NanoCharts milestone release v0.51

  1. Hip2b2 | #1
    On October 20, 2008 7:35 pm

    Wonderful effort with better visuals than commercial packages.

    Any plans to issue “final update” with Data in rows as well as column capability?

    Thanks

  2. TF | #2
    On March 1, 2008 12:55 am

    I really like how it works. While it added itself into excel, I can’t use it in other spreadsheets, due a naming conflict. Excel is complaining ” ‘nanocharts_beta_051 (version 1).xls’ could not be found. Check the spelling of the file name, and verify that the file location is correct.”

    The file down loaded is ‘nanocharts_beta_051.xls’. Any chance of getting a look at the VBA behind this?

    Thanks,

    Tom

  3. Phil | #3
    On February 15, 2008 9:10 pm

    I get a Run-time error ’1004′

    Unable to set the MaximumScale property of the Axis class.

    Win XP, Excel 2003

  4. Jesper | #4
    On November 22, 2007 11:45 pm

    Hi
    Im not sure what might cause that problem. If you select and copy the table + charts and then paste special as HTML in word it should work fine? Does for me.

    Regards
    Jesper

  5. J. | #5
    On November 14, 2007 2:55 pm

    If you copy/paste your table including nanocharts in Word, you’ve got some weird empty box. Do the generated charts consist of 2 layers? Just 1 layer would be easier.

  6. Jesper | #6
    On November 8, 2007 10:55 am

    That’s something I want to do actually. Thanks for the input and please check back. :)

  7. J. | #7
    On November 8, 2007 10:24 am

    Maybe an idea for your next version, is to have the user select the target cell of the graphic with the options for example: right,bottom,left,user select.

    keep up the good work!

Trackbacks/Pingbacks: