Clustered Column Chart with two different colours inside each column

[Anonymous]

I have the following data

Year by Year Investment Budget (with two categories)
Year by Year Investmnet Actual Expenses (with the same two categories)

Right now I'm showing a Clustered Column Chart that shows for each year two columns comparing the Budget and Actual expenses next to each other.

I need to have inside each column two different colours that will show the two categories I have.

Right Now I'm using the default Clustered Column Chart with this fields:

Axis: Year

Value:  - Sum of Budget

            - Sum of Actual

How can I get the two colours with the category field

[v-yuta-msft]

Hi scostas,

To achieve different color of categories, just put the category column to legend field in your chart.

Regards,

Jimmy Tao

[Anonymous]

The Visual doesn't allow me to add the category field to Legend. These is how I have the data right now.

The table contains all my investmetns with their categories their original budget and the forecast (which for the previous years it's what the final expenses where. What I need is to have each column bearing two colours (I have only two categories that I will be showing).

The categories are basically indication if the project was in the original investment plan or not.

The first column will always show only one colour because all the projects with a value in Budget belonged to the category that belonged to the original budget. But the forecast will have  mix of the two colours, showing the value for the investments from the original budget that was done and the aditional value for new investmetns that was added.