• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Color Coding Excel Bars

J

JuliusV

Member
I am trying to figure out how I can color code bars in excel based on where the data is from.
What I mean is the following:

The graphs are:
x-axis = Dates
y-axis = Money

Color Coding for Funds:
Fund 1 - Red
Fund 1 - RedFund 1 - Red
Fund 2 - Blue
Fund 2 - Blue
Fund 3 - Green
Fund 3 - GreenFund 3 - Green
Fund 3 - Green
ect.

I want to be able to find a way without VBA on how I can color code based on the Fund Number.

Thanks for the help.
 
Is there another method that would not require me to create multiple columns?
I have thousands of data points with hundreds of funds and this method would take longer than me click on the bars and re-coloring them.
 
Attached is a spreadsheet demonstrating an example of the data set with a sample graph.

I am trying to find a way so that the color scheme of the bar graph will correspond with the Fund Number.

The fund numbers are not necessarily in order either, however, the Dates are in order, which is what I want to maintain. For example, the fund order could be, but the dates are in order

Fund 1 - Feb 20 1990
Fund 1 - Feb 20 1991
Fund 3- Feb 20 1992
Fund 2 - Feb 20 1993
Fund 1 - Feb 20 1994
Fund 1 - Feb 20 1995
 

Attachments

Hi Julius ,

If you say that there are thousands of points , the first point is that having a thousand points is not going to allow the observer to see the forest for the trees ; secondly , if you say there are hundreds of funds , I really don't see any point in a graph , since I do not know who can distinguish the different shades in more than a hundred colours.

I suggest you do something which allows the user to interact with the graph ; have two listboxes which will allow th user to select any 2 funds so that they can be compared against each other ; not only will this reduce the amount of information that the user has to cope with , it will probably be more meaningful.

Your overall chart can probably have the top 5 performing funds , which will be a static chart and needs only 5 columns of data.

If you want , a second chart can have the bottom 5 performing funds.

Narayan
 
Hi Narayan,

The main purpose is not to identify whether a fund is top performing or not, since the Funds I am analyzing are already the top performing.

I am interested in identifying a pattern within the current Fund Cycle that the Fund is in. Looking at the top or lowest performing funds will not allow me to validate the patterns that I identify within each specific fund cycle.

i..e If I notice that each fund cycle seems to have a normally distributed shape (not saying it is norm dist), then when looking at an aggregated timeline I would expect that for each fund cycle, there would be multiple normally distributed looking shapes.

That is why I am trying to figure out a way to color code it.
 
Hi Julius ,

If that is so , why do you need to look at hundreds of funds ? Surely the long-term pattern of change within a single fund will be visible even if that is the only fund plotted on the graph ?

Narayan
 
Narayan,

The point of plotting the aggregated timeline is to make it obvious that there is a pattern, since there will be a pattern noticeable within every fund cycle.

JuliusV
 
You must log in or register to reply here.
Back
Top