Importing Symbols in Excel for charting

[Boon8888]

Hi, I'm just wondering if it is possible to import your own symbols in
Excel to be used in charting?

This would be very useful for me for example, when listing weather on
charts for particular dates. Currently, I just use a symbol like a red
square to denote heavy rain. It would be nice to be able to use an
imported symbol, like a dark cloud with rain shape, to denote the heavy
rain.

I would like to do this within a data series, and not simply copy and
paste a symbol several times and place it on the graph.

Does anyone have any idea how or if this can be done?

Thanks.

 

[Guest]

Have a look at the various "Wingding" fonts.

 

[Guest]

Sorry, my previous reply was probably not much help.

Why don't you import the symbols just the once, then use IF statements that
refer to the symbols. Does that make sense?

 

[Guest]

Try this:

On the chart, select one of the series
Right-click and select: Format Data Series
Select the Patterns tab
Click the [Fill Effects] button
Select the Picture tab
Click the [Select Picture] button

Once the picture is selected, the data series will plot that picture instead
of one of the Excel patterns.


Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

 

[schnett]

The "fill effects" do not associate with all series. For example if you
are using XY series there are not any fill effects. Instead you may
want follow these steps :
1. Simply draw your item on a separate worksheet or import the picture
2. Right click and copy that item you just drew
3. Click on the graph and then the series. Make sure you it selects the
whole series.
4. Press Cntrl + V (This pastes your item at every data point)

Hope this helps

 

[Boon8888]

Thanks for all the posts guys! I'm sure at least one of your
suggestions will work great for me. Thanks again.

Joel