Micrsosoft Ecel 2013: Charts & Conditional Format Icon Set?

[CrystalFacets]

Is there a way to include Microsoft Excel's conditional formatting icon set inside a chart -- as either part of the data label or attached to chart as part of the data table (or other solution)?

I've not had success in doing so using Excel features on the ribbon. The closest I've come is an article that shows one how to create a your own icon set using Excel's 'Insert >> Object' and then how to include those objects as part of the chart's data table.

Thank you in advance for feedback.

 

[SkipVought]

Hi,

You could consider using a separate series for each CF.

However, without a working example, pretty hard to imagine what you're looking at.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[CrystalFacets]

Hi, Skip,

I did use separate CF for each radio icon.

Also, thought I had attached zipped file with docs and re-attaching again. Let me know if you receive the zipped file this time. Thanks.

 

[CrystalFacets]

Skip,
Disregard file attached. Has nothing to do with this issue. Will create & send another file.

 

[SkipVought]

Thx

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[CrystalFacets]

Okay. Attached a file re: charting and whether or not icon set can be added to graph.

 

[CrystalFacets]

Skip,
If helpful, here's the link to the video about creating your own icon set and adding to chart as part of the data table. I'm hoping there's a solution that allows one to use the existing icon set already inside Excel.

Link:

http://www.myonlinetraininghub.com/excel-dashboard-course

 

[SkipVought]

Your revised table
[pre]
Sources Actual Benchmark HelperCol Green Yellow Red
Source 1 27.84% 27.84% 1.0000 1 0 0
Source 2 27.30% 34.62% 0.7886 0 0 0.7886
Source 3 36.49% 36.31% 1.0050 1.0050 0 0
Source 4 31.56% 37.91% 0.8325 0 0.8325 0
[/pre]

The formula under...
[tt]
Green: =IF(F3>0.99,F3,0)
Yellow: =IF(AND(F3<=0.99,F3>0.8),F3,0)
Red: =IF(F3<=0.8,F3,0)
[/tt]

...and the workbook is attached.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[CrystalFacets]

Skip,

See updated file, Sheet2 and 'Chart 2' starting in row 29. I've added some clarity. Bars in chart must represent 'Actual' column. My wish is to add icon symbol to the data label.

Or, as a 2nd choice, the icon symbol could be added to data table. The reason my preference is to add to data label is that it would hopefully save space.

 

[SkipVought]

Used faq68-7518

See uploaded workbook.

The process:
[tt]
1) SELECT the cell containing the first CF Traffic Light Icon
2) Hit the Camera Icon
3) Move mouse to empty cell
4) COPY the Camera Picture
5) Select anywhere in the Chart Area
6) PASTE
7) Immediately select in the Formula Bar, type = and then Select the First CF Traffic Light cell.
8) MOVE the Camera Picture to the appropriate location.
9) Repeat steps 4) to 8) for the next three CFs.
[/tt]

Finally, delete the Camera Picture in your sheet that you've been copying from.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[CrystalFacets]

Thank you, Skip. I'll see if I can make this work.