Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

Register a free account to unlock additional features at BleepingComputer.com

Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.

Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Latest News: BORN Ontario child registry data breach affects 3.4 million people

Featured Deal: Get started in AI or make your own with this $19.97 course bundle

Latest Buyer's Guide: Best VPNs to unblock Stan outside Australia in 2023

How to make legend display the name of a color given a range?

Started by Bluebuster116 , Feb 14 2023 11:59 AM

Please log in to reply

3 replies to this topic

#1 Bluebuster116

Members
43 posts
OFFLINE

Local time:09:52 PM

Posted 14 February 2023 - 11:59 AM

I am trying to do this in Excel but I don't know how.

Let's say that I have this table:

Results

A 20%

B 30%

C 50%

What I want to do is to use a horizontal bar chart so that a legend indicates only the values above or equal to 50 percent and say the word Achieved. This legend must be of blue color.

In the chart the bars which are below 50 percent should be orange and the ones greater or equal 50 blue.

I could use the paint bucket tool to change the colors manually but by doing so the legend individually puts the names of each row by colors and I don't want that.

Does anybody knows how to do what I need?. It would be nice if a screenshot is added in the response as I am still novice in Excel.

Does it exist a command or a function for this?. By the way I am using Excel 2007 so it would be nice if the command or answer is supported on my version. Help me please?.

Edited by Bluebuster116, 14 February 2023 - 01:48 PM.

Back to top"> Back to top

BC AdBot (Login to Remove)

BleepingComputer.com
Register to remove ads

#2 greg18

Members
1,565 posts
OFFLINE

Gender:Male
Location:Los Angeles, CA
Local time:07:52 PM

Posted 18 February 2023 - 12:56 PM

You do it in the chart once you have that information create it in Excel with the data in those cells you choose to be in your chart.

Back to top"> Back to top

#3 Bluebuster116

Topic Starter

Members
43 posts
OFFLINE

Local time:09:52 PM

Posted 20 February 2023 - 04:38 PM

You do it in the chart once you have that information create it in Excel with the data in those cells you choose to be in your chart.

This isn't really an answer. I did that and I am not getting the result I need. Again, whenever I manually change the color of the bars when the chart has been created a new entry is made in the legend section indicating the name of the category which I had assigned for the previous color. This produces a duplicate in the information I intend to display in the legend.

Can somone please share an example so I could guide myself or something?. It would be nice to have a screenshot for verification.