9 Replies Latest reply: Nov 21, 2015 2:32 AM by Purvendra Kumar

# How to make bars with different equation on a bar chart?

My problem is that I have to display different bars with different equations on a single bar chart.

For example:- I have 3 fields in my excel sheet. I want to make one stacked bar for each field and show them on the same bar chart.

Please help!

Thanks in anticipation!

• ###### Re: How to make bars with different equation on a bar chart?

can you provide an example of what you want

• ###### Re: How to make bars with different equation on a bar chart?

Hi Ramon,

Sorry for late reply!

Let us say there are 5 different dimensions. Each dimension has it's own segments.

I want to show stacked bars for each 5 dimensions showing their respective segments .

Thanks in anticipation.

• ###### Re: How to make bars with different equation on a bar chart?

Hi Ramon,

I have provided the example of my data in above comment.

Please help!

Thanks in anticipation.

• ###### Re: How to make bars with different equation on a bar chart?

are these going to be 1 dimension  with 3 different expressions or 3 dimensions

can you provide a sample of the excel and/or any qvw you may have started?

• ###### Re: How to make bars with different equation on a bar chart?

Hi Adam,

There are 5 different dimensions.

• ###### Re: How to make bars with different equation on a bar chart?

maybe using

```ValueList('bar1','bar2','bar3')
```

as one (calculated) dimension and

```Pick(Match(ValueList('bar1','bar2','bar3'),'bar1','bar2','bar3'),expression1,expression2,expression3)
```

as expression.

hope this helps

regards

Marco

• ###### Re: How to make bars with different equation on a bar chart?

Hi Webel,

What am I supposed to write in place of bar1, bar2, bar3..

Sample data is following:-

Response id     Quarter       Dimension-1      Dimension-2     Dimension-3

101                  Q1               Yes                    No                    Yes

102                  Q1               Yes                    Yes                    No

103                  Q2               No                      Yes                    Yes

104                  Q2               No                      No                    No

105                 Q3               No                      Yes                    Yes

106                 Q3               Yes                    No                    No

107                Q3               No                      Yes                    Yes

108                Q4               Yes

109               Q4               No                                                  Yes

110               Q4               Yes                    No                         Yes

111               Q5                                        Yes                         No

112                 Q5               No                      Yes                        Yes

113                Q5               Yes                    Yes                         Yes

114                 Q5

115                 Q5               No                       No                         No

I want to show one bar for each dimension. If it can be shown as 5 bars grouped together for one dimension and all three dimensions on one single chart then better.

Otherwise, at least what I need is to show all three dimensions on one single chart. Each bar having it's own equation.

• ###### Re: How to make bars with different equation on a bar chart?

you need to write the name of the dimensions

• ###### Re: How to make bars with different equation on a bar chart?

Hi Ramon,

I tried doing that but it didn't work.

Can you please share the QV file using above data?

It will be a great help.

Thanks in anticipation!