List of all comments (excel vba)

One Response to “List of all comments (excel vba)”

  1. Ola says:

    The starting point of a Circular reference errors isn't always so easy to find.
    http://www.extendoffice.com/documents/excel/1049-excel-identify-locate-circular-reference.html

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to upload a file
Upload file

Use pictures in a column chart

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to upload a file
Upload file

Build a comparison chart

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to upload a file
Upload file

Add pictures to a chart axis

4 Responses to “Add pictures to a chart axis”

  1. Darin Myers says:

    Great technique and one I have not seen before.

    For those that may not know, you can add a custom number format to the axis to remove the negative numbers if you don't need them. Just right-click and format the axis. Then from number choose custom, and enter the positive number format, a semicolon, keep it blank for the negative numbers, a semicolon, and then the format that you want for zero (you can use a blank here if you want to remove the zero too) For example, I would use 0;;0 for this chart.

  2. Ola says:

    Thanks for a great idea. I'll use it.
    //Ola

    Made one small improvement:
    To auto-adjust the flag position when the maximum value change.
    D3toD7: =MAX($C$3:$C$7)*(-1,5/22) -- chart size constant
    and change...Format Axis, Bounds, Minimum to Auto

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to upload a file
Upload file

Group data by quarters

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to upload a file
Upload file