Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Micrsosoft Ecel 2013: Charts & Conditional Format Icon Set?

Status
Not open for further replies.

CrystalFacets

Technical User
Nov 3, 2016
28
US
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.
 
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]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
 
Skip,
Disregard file attached. Has nothing to do with this issue. Will create & send another file.
 
Thx

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
 
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]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
 
 http://files.engineering.com/getfile.aspx?folder=d89bc348-371b-4c56-8272-fea0f69f7f94&file=Charts_w_Cond_Format_Icons-TT.xlsx
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.
 
 http://files.engineering.com/getfile.aspx?folder=9993b8c9-a933-46c6-b315-244f021314ca&file=Charts_w_Cond_Format_Icons-TT_v2.xlsx
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]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
 
 http://files.engineering.com/getfile.aspx?folder=be9f7471-c151-40c0-a781-0fd30fa326a5&file=Charts_w_Cond_Format_Icons-TT_v2.xlsx
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top