Jump to content
We've recently updated our Privacy Statement, available here. ×

How to show a specific categorical variable in a bar graph with next top X


Greg Gibble

Recommended Posts

So I am trying to create a Spotfirebar graph to represent some sales infmoration based on a few different companies. For example lets say I have companies A,B,C,D,E,F,G and the company of focus is company A. I want to have a bar graph that will show the top X (lets say 3 in this situation) and company A even if company A is not in the top three.

For example if the data was

 

 

 

Company

Sales

 

 

A

100

 

 

B

50

 

 

C

150

 

 

D

200

 

 

E

250

 

 

F

300

 

 

 

I would want a bar graph that would show company A then companies D,E,F.

Is this possible to do in one graph I know I could make 2 different charts on one page and have on graph only point to my company of interest but I would like to see if this is possible to do in one graph. Also if this can be transfered to pie charts etc. as well, please let me know.

 

Thank you,

Greg

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...