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.

[James Hamilton]

Have a look at the various "Wingding" fonts.

"Boon8888" wrote:

>
> 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.
>
>
> --
> Boon8888
> ------------------------------------------------------------------------
> Boon8888's Profile: http://www.excelforum.com/member.php...o&userid=30647
> View this thread: http://www.excelforum.com/showthread...hreadid=534374
>
>

[James Hamilton]

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?

"Boon8888" wrote:

>
> 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.
>
>
> --
> Boon8888
> ------------------------------------------------------------------------
> Boon8888's Profile: http://www.excelforum.com/member.php...o&userid=30647
> View this thread: http://www.excelforum.com/showthread...hreadid=534374
>
>

[Ron Coderre]

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


"Boon8888" wrote:

>
> 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.
>
>
> --
> Boon8888
> ------------------------------------------------------------------------
> Boon8888's Profile: http://www.excelforum.com/member.php...o&userid=30647
> View this thread: http://www.excelforum.com/showthread...hreadid=534374
>
>

[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