# General discussion **URL:** https://forum.xltoolbox.net/c/old-forum/general-discussion/10.md [Latest](https://forum.xltoolbox.net/latest.md) · [Categories](https://forum.xltoolbox.net/categories.md) · [Tags](https://forum.xltoolbox.net/tags.md) --- ## [About the General discussion category](https://forum.xltoolbox.net/t/about-the-general-discussion-category/16)
**Author:** [@system](https://forum.xltoolbox.net/u/system)\ **Replies:** 0\ **Last updated:** [April 21, 2013, 8:15am UTC](https://forum.xltoolbox.net/t/about-the-general-discussion-category/16 "2013-04-21T08:15:29Z")
--- ## [Export for publication](https://forum.xltoolbox.net/t/export-for-publication/48)
**Author:** [@Peter](https://forum.xltoolbox.net/u/Peter)\ **Replies:** 12\ **Last updated:** [July 18, 2024, 9:05am UTC](https://forum.xltoolbox.net/t/export-for-publication/48 "2024-07-18T09:05:27Z")
Hi Daniel, About a year ago, someone posted an issue with "export for publication", which I quoted below. "Unable to create a canvas to draw the image. This indicates a problem with the windows GDI graphic sub system. … --- ## [Hello Everyone,](https://forum.xltoolbox.net/t/hello-everyone/55)
**Author:** [@017hnoor](https://forum.xltoolbox.net/u/017hnoor)\ **Replies:** 6\ **Last updated:** [January 21, 2018, 5:42pm UTC](https://forum.xltoolbox.net/t/hello-everyone/55 "2018-01-21T17:42:49Z")
Hello Everyone, I exported Excel charts as TIF to be used for a scientific publication. This specific journal allows the upload of charts as either TIF or alternatively as PDF. Following the upload of files a PDF documen… --- ## [Cannot use ANOVA posthoc tests](https://forum.xltoolbox.net/t/cannot-use-anova-posthoc-tests/54)
**Author:** [@Salwa](https://forum.xltoolbox.net/u/Salwa)\ **Replies:** 3\ **Last updated:** [November 10, 2016, 4:33am UTC](https://forum.xltoolbox.net/t/cannot-use-anova-posthoc-tests/54 "2016-11-10T04:33:48Z")
I am new to statistics and found XLToolbox. I was able to run ANOVA but the posthos/multiple tab is grayed. Why is that? I have five specific groups to run --- ## [Fixed width vs CSV](https://forum.xltoolbox.net/t/fixed-width-vs-csv/68)
**Author:** [@asjones123](https://forum.xltoolbox.net/u/asjones123)\ **Replies:** 7\ **Last updated:** [November 7, 2016, 5:26pm UTC](https://forum.xltoolbox.net/t/fixed-width-vs-csv/68 "2016-11-07T17:26:12Z")
Was curious if you had considered or looked into a fixed width export tool and not just CSV? I have seen so many cases where fixed width can be nice as it gets around quotes in text fields and other things. Also reali… --- ## [Excel 32bit vs 64bit](https://forum.xltoolbox.net/t/excel-32bit-vs-64bit/67)
**Author:** [@asjones123](https://forum.xltoolbox.net/u/asjones123)\ **Replies:** 1\ **Last updated:** [September 24, 2016, 5:41am UTC](https://forum.xltoolbox.net/t/excel-32bit-vs-64bit/67 "2016-09-24T05:41:32Z")
I am going to be migrating from Excel 32bit to 64bit and wanted to know if there were any known issues with the XL Toolbox? Either the new features migrated to the 7.x standard or the old ones that have not been rewritt… --- ## [Vb.net](https://forum.xltoolbox.net/t/vb-net/66)
**Author:** [@Mandra\_2016](https://forum.xltoolbox.net/u/Mandra_2016)\ **Replies:** 0\ **Last updated:** [April 8, 2016, 4:11pm UTC](https://forum.xltoolbox.net/t/vb-net/66 "2016-04-08T16:11:33Z")
1 I am new to vb.net 2º i have many graphic files excel 1 each and I want to export to pdf in vb.net I have the chart in vb.net xlWB.ActiveSheet.ChartObjects ( 1) .Chart but I try to export with your api and adding … --- ## [Not tested p vaules and p value 0.1](https://forum.xltoolbox.net/t/not-tested-p-vaules-and-p-value-0-1/65)
**Author:** [@dwb5555](https://forum.xltoolbox.net/u/dwb5555)\ **Replies:** 2\ **Last updated:** [March 24, 2016, 4:46pm UTC](https://forum.xltoolbox.net/t/not-tested-p-vaules-and-p-value-0-1/65 "2016-03-24T16:46:28Z")
Hello Currently, when running Anova the program will have a read out of (not tested) when the data does not fit the set parameters. Would it be possible to show the p-vaules even if the parameters are not meet. This ca… --- ## [Export for publication - figures cut off](https://forum.xltoolbox.net/t/export-for-publication-figures-cut-off/64)
**Author:** [@laura27md](https://forum.xltoolbox.net/u/laura27md)\ **Replies:** 2\ **Last updated:** [March 3, 2016, 10:23am UTC](https://forum.xltoolbox.net/t/export-for-publication-figures-cut-off/64 "2016-03-03T10:23:17Z")
Hello, I am using the export for publication feature and it was working well temporarily. I needed to modify the figures, and now, any figures I try to export are cut off. Only about 75% of the figure is in the file. I h… --- ## [Office 2016](https://forum.xltoolbox.net/t/office-2016/62)
**Author:** [@asjones123](https://forum.xltoolbox.net/u/asjones123)\ **Replies:** 1\ **Last updated:** [January 13, 2016, 4:29pm UTC](https://forum.xltoolbox.net/t/office-2016/62 "2016-01-13T16:29:48Z")
I am going to be moving to Office 2016. Any known issues or anything I should be aware of with Excel 2016 and Daniel's XL Toolbox or the NG version? thanks Alan --- ## [Can I turn off the flash picture when starting Excel?](https://forum.xltoolbox.net/t/can-i-turn-off-the-flash-picture-when-starting-excel/61)
**Author:** [@lingSP](https://forum.xltoolbox.net/u/lingSP)\ **Replies:** 2\ **Last updated:** [November 19, 2015, 6:41pm UTC](https://forum.xltoolbox.net/t/can-i-turn-off-the-flash-picture-when-starting-excel/61 "2015-11-19T18:41:17Z")
Dear users, does anyone know a way to turn off the "welcome" start-up flash picture of this toolbox upon starting Excel? I would like to turn it off but haven't found the means to do so after exploring all preference opt… --- ## [Error bars problem](https://forum.xltoolbox.net/t/error-bars-problem/60)
**Author:** [@blackneon](https://forum.xltoolbox.net/u/blackneon)\ **Replies:** 2\ **Last updated:** [November 12, 2015, 4:46am UTC](https://forum.xltoolbox.net/t/error-bars-problem/60 "2015-11-12T04:46:48Z")
hello everybody, I am trying to apply the error bars automatically to a big number of graphs. I start selecting the already done histogram graph, by clicking shift and error bars \> after moving to the desired values (I… --- ## [Is there any manual or DOC to know how to use](https://forum.xltoolbox.net/t/is-there-any-manual-or-doc-to-know-how-to-use/59)
**Author:** [@Atonau2004](https://forum.xltoolbox.net/u/Atonau2004)\ **Replies:** 1\ **Last updated:** [October 19, 2015, 4:14am UTC](https://forum.xltoolbox.net/t/is-there-any-manual-or-doc-to-know-how-to-use/59 "2015-10-19T04:14:30Z")
I allready install the toolbox.... but.... how to use it???? --- ## [Avast - Mo97:Donwloader:CK](https://forum.xltoolbox.net/t/avast-mo97-donwloader-ck/58)
**Author:** [@j77](https://forum.xltoolbox.net/u/j77)\ **Replies:** 2\ **Last updated:** [May 8, 2015, 5:37pm UTC](https://forum.xltoolbox.net/t/avast-mo97-donwloader-ck/58 "2015-05-08T17:37:11Z")
Hi, just finished downloading from sourceforge and upon download completion, avast reported Mo97:Donwloader:CK please advise, Thank you. John --- ## [I can't download the newest version](https://forum.xltoolbox.net/t/i-cant-download-the-newest-version/56)
**Author:** [@miruna](https://forum.xltoolbox.net/u/miruna)\ **Replies:** 1\ **Last updated:** [May 7, 2015, 6:32am UTC](https://forum.xltoolbox.net/t/i-cant-download-the-newest-version/56 "2015-05-07T06:32:11Z")
I am trying to download the ver. 6.60 but it can't be completed. Although I have installed other previous versions, when I open the Excel file the XL Toolbox add in is not activated. Please, do you have any suggestion? T… --- ## [Toolbox does not install correctly](https://forum.xltoolbox.net/t/toolbox-does-not-install-correctly/53)
**Author:** [@Collin](https://forum.xltoolbox.net/u/Collin)\ **Replies:** 1\ **Last updated:** [April 4, 2015, 7:39am UTC](https://forum.xltoolbox.net/t/toolbox-does-not-install-correctly/53 "2015-04-04T07:39:51Z")
I have tried to install the new version of the xl toolkit in a PC with Windows 7, and Excel 2007. When I tried to run the installation program I got an error message saying that Excel was open, but Excel was closed. Afte… --- ## [Error bars with Excel 2013 - Both top and bottom tail](https://forum.xltoolbox.net/t/error-bars-with-excel-2013-both-top-and-bottom-tail/40)
**Author:** [@thetoiletduck](https://forum.xltoolbox.net/u/thetoiletduck)\ **Replies:** 2\ **Last updated:** [March 30, 2015, 3:43am UTC](https://forum.xltoolbox.net/t/error-bars-with-excel-2013-both-top-and-bottom-tail/40 "2015-03-30T03:43:53Z")
Hiya, I was wondering if there's a way to default error bars to top and bottom in Excel 2013? When using an older version of excel it would do both tails as default with the cell locations automatically pasted in, but … --- ## [How to annotate only some of the data points for a line graph](https://forum.xltoolbox.net/t/how-to-annotate-only-some-of-the-data-points-for-a-line-graph/50)
**Author:** [@Kokab](https://forum.xltoolbox.net/u/Kokab)\ **Replies:** 2\ **Last updated:** [March 17, 2015, 7:18am UTC](https://forum.xltoolbox.net/t/how-to-annotate-only-some-of-the-data-points-for-a-line-graph/50 "2015-03-17T07:18:49Z")
Hi, How do I annotate only some of the data points for a line graph? I want to add asterisks and other symbols to denote significance for only some of the data points on the line graph, however it seems I can only annota… --- ## [Chart annotation improvements](https://forum.xltoolbox.net/t/chart-annotation-improvements/51)
**Author:** [@telenor](https://forum.xltoolbox.net/u/telenor)\ **Replies:** 1\ **Last updated:** [March 4, 2015, 8:22pm UTC](https://forum.xltoolbox.net/t/chart-annotation-improvements/51 "2015-03-04T20:22:37Z")
In other related posts, the question arises whether comments are a possible alternative to an annotation column. In a sense, the answer is always yes, if you're willing to go to enough work. But a coulmn for the annotati… --- ## [I noticed a thread in 2013 looking at a bug with the following error:](https://forum.xltoolbox.net/t/i-noticed-a-thread-in-2013-looking-at-a-bug-with-the-following-error/52)
**Author:** [@curieroy](https://forum.xltoolbox.net/u/curieroy)\ **Replies:** 2\ **Last updated:** [March 4, 2015, 8:02am UTC](https://forum.xltoolbox.net/t/i-noticed-a-thread-in-2013-looking-at-a-bug-with-the-following-error/52 "2015-03-04T08:02:26Z")
Unable to create a canvas to draw image. This indicates a problem with the Windows GDI graphic subsystem. Was this resolved? Similar, The batch export command comes up with an error stating that the charts could not be e… --- ## [Export for publication function of xltoolbox](https://forum.xltoolbox.net/t/export-for-publication-function-of-xltoolbox/41)
**Author:** [@saisudhir](https://forum.xltoolbox.net/u/saisudhir)\ **Replies:** 4\ **Last updated:** [February 20, 2015, 9:29am UTC](https://forum.xltoolbox.net/t/export-for-publication-function-of-xltoolbox/41 "2015-02-20T09:29:29Z")
Hi Firstly thank you Daniel for this wonderful addin and everyone in our circle of friends find this extremely useful. This is my first post and so quickly tried search with keyword powerpoint and found nothing, hen… --- ## [4 Quadrant Charts with optional labels/colors](https://forum.xltoolbox.net/t/4-quadrant-charts-with-optional-labels-colors/24)
**Author:** [@asjones123](https://forum.xltoolbox.net/u/asjones123)\ **Replies:** 3\ **Last updated:** [February 16, 2015, 7:00am UTC](https://forum.xltoolbox.net/t/4-quadrant-charts-with-optional-labels-colors/24 "2015-02-16T07:00:28Z")
I was wondering if you had considered adding features to improve making a 4 Quadrant Chart with Optional Labels or multiple colors, etc. Basically a generic version of the Magic Quadrant with X/y axis labeled as desired… --- ## [Old forum thread - Windows GDI graphic subsystem](https://forum.xltoolbox.net/t/old-forum-thread-windows-gdi-graphic-subsystem/29)
**Author:** [@yguisard](https://forum.xltoolbox.net/u/yguisard)\ **Replies:** 4\ **Last updated:** [February 2, 2015, 5:49am UTC](https://forum.xltoolbox.net/t/old-forum-thread-windows-gdi-graphic-subsystem/29 "2015-02-02T05:49:19Z")
Hi and thanks for this great tool. I noticed a thread in 2013 looking at a bug with the following error: Unable to create a canvas to draw image. This indicates a problem with the Windows GDI graphic subsystem. Was t… --- ## [Coloring a line chart](https://forum.xltoolbox.net/t/coloring-a-line-chart/35)
**Author:** [@jalea148](https://forum.xltoolbox.net/u/jalea148)\ **Replies:** 2\ **Last updated:** [January 21, 2015, 5:55am UTC](https://forum.xltoolbox.net/t/coloring-a-line-chart/35 "2015-01-21T05:55:42Z")
Imagine plotting a sine wave green from -1 to 1 and red from 1 to -1. I have a few thousand data points and with each a parameter \[0 or 1\]. I want to plot then line chart of the data, green when parameter = 1 and red whe… --- ## [Excel 2010 and solver error 53](https://forum.xltoolbox.net/t/excel-2010-and-solver-error-53/25)
**Author:** [@jkshihadeh](https://forum.xltoolbox.net/u/jkshihadeh)\ **Replies:** 6\ **Last updated:** [January 14, 2015, 6:38am UTC](https://forum.xltoolbox.net/t/excel-2010-and-solver-error-53/25 "2015-01-14T06:38:55Z")
Hi Daniel, You've previously tried to address this issue from another user within this post: sourceforge.net/p/xltoolbox/disc ... /0fe4f8a6/ I've encountered the same issue but with Excel 2010 in Windows 7. I underst… --- ## [XLTB develop flow](https://forum.xltoolbox.net/t/xltb-develop-flow/37)
**Author:** [@Dario](https://forum.xltoolbox.net/u/Dario)\ **Replies:** 3\ **Last updated:** [January 6, 2015, 6:07am UTC](https://forum.xltoolbox.net/t/xltb-develop-flow/37 "2015-01-06T06:07:50Z")
Hi! This is my second post here! Thanks again for your toolbox, it is very very useful! If I may ask, my question is rather a curiosity about how you are developing XLTB.. Since I've been using excel for a while I've… --- ## [Problem exporting figures for publication](https://forum.xltoolbox.net/t/problem-exporting-figures-for-publication/19)
**Author:** [@gertbra](https://forum.xltoolbox.net/u/gertbra)\ **Replies:** 10\ **Last updated:** [January 6, 2015, 5:53am UTC](https://forum.xltoolbox.net/t/problem-exporting-figures-for-publication/19 "2015-01-06T05:53:49Z")
It gives me the following error: "Freeimage DLL is not available" How can I solve this? Thank you --- ## [\[FR\] option to set diagram export defaults](https://forum.xltoolbox.net/t/fr-option-to-set-diagram-export-defaults/26)
**Author:** [@cemibu](https://forum.xltoolbox.net/u/cemibu)\ **Replies:** 5\ **Last updated:** [January 6, 2015, 5:46am UTC](https://forum.xltoolbox.net/t/fr-option-to-set-diagram-export-defaults/26 "2015-01-06T05:46:11Z")
Hello! Thanks so much for this useful plugin! It already helped me export a lot of diagrams for presentations, so I happily donated :slight\_smile: I only found it to be more click-intensive to get the desired result th… --- ## [Exporting PNG or TIFF charts with transparent background](https://forum.xltoolbox.net/t/exporting-png-or-tiff-charts-with-transparent-background/33)
**Author:** [@adinnes85](https://forum.xltoolbox.net/u/adinnes85)\ **Replies:** 4\ **Last updated:** [January 6, 2015, 4:52am UTC](https://forum.xltoolbox.net/t/exporting-png-or-tiff-charts-with-transparent-background/33 "2015-01-06T04:52:19Z")
I am using the VBA api to automatically export charts. Originally, I exported them as EMF files and by turning the chart background to 'no fill' I could get the backgrounds of the exported charts to be transparent. Howev… --- ## [Annotating a stacked column chart](https://forum.xltoolbox.net/t/annotating-a-stacked-column-chart/49)
**Author:** [@Llaves](https://forum.xltoolbox.net/u/Llaves)\ **Replies:** 2\ **Last updated:** [December 23, 2014, 9:32am UTC](https://forum.xltoolbox.net/t/annotating-a-stacked-column-chart/49 "2014-12-23T09:32:50Z")
I'm trying to annotate a stacked column chart and want only a single annotation at the top of the stacked columns. From other posts I figured out I have to use comment rather than cells, since the cells will be applied t… [Next page](https://forum.xltoolbox.net/c/old-forum/general-discussion/10.md?page=1)