Bar chart colour by dimension

Mon Rozkiewicz shared this question 8 months ago
Answered

Hi,

I am creating a bar chart and colouring by dimension, however, when I drag the dimension into colour the bars become extremely thin.

Could someone please help me to change the width of the bars or advise how to better colour the bars without having to create reference codes.

Many thanks,

Mon

/4478430f1429411ea4fbdacdcbbe036f

Comments (1)

photo
1

Hi Mon,


Thank you for sending that through.


Firstly, I wanted to check which version and build of Yellowfin you are using. You can find this information on the /info.jsp page. I have tried to replicate this, however I haven't had any luck. If you are using a version of 7.4.12 that was recently published, it has recently been republished with some fixes that were noticed over the last couple of days may resolve this issue.


Following on from the previous point, I have a few more questions that will help me understand your issue:

  • When did you first notice this issue?
  • What kind of chart are you trying to build - are you using the autochart feature or another option?
  • How many unique values are found in the field, what is displaying in the legend below the chart

Let me know how you go.


Regards,

Simon

photo
1

Hi Simon,

Thank you for your prompt response.

I went to /info.jsp and it is saying that the version if 8.0.3 however I thought we were using version 7.

I am new to Yellowfin (2-3 months) and I have always had this issue.

I am building a bar chart - when I use Auto Chart this error doesn't occur, however the Auto Chart option doesn't allow for other features that I require.

A legend appears on the bottom of the chart when I use colour by dimension.

There are 13 unique values.

Let me know if you require any further details.

Many thanks,

Mon

photo
2

Hi Mon,


I was able to replicate what you are seeing, through creating a Horizontal Bar Chart in Yellowfin 8.0.3. This is working as expected, as when you are entering the field with 13 values into the 'Color' section of the chart, it is expecting within your vertical axis, there will be 13 unique values within each of your 13 measures. Another way you could think of it is that for the Year 10/11 metric, there are ~2500 values for Year 10/11 and 0 for the other 12 measures, repeated for each of the other metrics.


In order to get around this, I suggest creating a Horizontal Stacked Bar Chart instead and using your desired field in the colour section, as this won't separate the width, rather 'stack' different values and different colours on top of each other. You can also definitely use Reference Codes to do this.


Let me know if this solves your issue.


Regards,

Simon

photo
1

Hi Simon,

Thank you very much for your help.

I created a Stacked Bar Chart and it solved the problem.

Enjoy your day.

Kind regards,

Mon

photo
1

Hi Mon,


Great to hear!


If you have any other issues regarding this topic, feel free to comment and we will be sure to assist you.


Regards,

Simon

photo