How to create a special diagram

Question

How to create a special diagram

Hi....I`m looking for the way, how to create a bar diagram, which has 9 sets of 3 numbers in the background. What I need is the first 3 numbers should be shown in the diagram in the same color....the next 3 numbers also in the same, but different color.....and so on for the whole 9 sets of 3 numbers...got it?

The problem is, when I choose the basic bar-diagram, the colors will mix and will not be the same within the sets of 3 numbers...

So, is there any way how to do it? ...hope I made my point clear...

L.

BTW - I seem to have the same problem with EXEL....

Posted on Jul 17, 2016 7:56 AM

Reply

Answer 1

Jul 17, 2016 9:10 AM in response to laszlofromberlin

Can you show an example of the data AND an example of a chart that presents the data like you want? Even just a screenshot of a chart

Reply

Answer 2

Jul 17, 2016 9:50 AM in response to Wayne Contello

Hi Wayne..here you are...hope it helps:

Reply

Answer 3

Barry

Level 9

60,023 points

Jul 17, 2016 10:51 AM in response to laszlofromberlin

Hi Laszlo,

How are the values on the table related to each other?

How would you label the columns and the rows to show this relationship?

What are you trying to show on the chart?

Regards,

Barry

Reply

Answer 4

Jul 17, 2016 11:21 AM in response to Barry

Hi Barry, the values in each column are related to each other in this way:

Each of the nine columns stands for a special kind of set of standards and values from participants of "personalty & value game" I will do with a company with ca. 70 participants.

The fist number of each column shows the individual set of standards/ values, the second number the experienced standards/ values and the third number the desired + favored standards/values within the company.

What I want to do is, to compare the individual, the experienced and the desired standards/values within each column and therefore need them to be in the same color.

Hope I explained it good enough to understand my purpose....Thanks L.

Reply