Forum Discussion

x-File's avatar
x-File
Helper I
3 years ago

How to stop summarizing values with different other values

Hi all,

 

I'm trying to make a bar chart, based on an excel-file (whihc I can not share here unfortunately).

On X-axis, the in-clinc period (each one is unique, even though they moght occur more than once). On Y-axis, the value per in-clinic period.

 

As you see, if the in-clinic period is 6 days, it shows multiple studies with that amount of in-clinc period, and it adds the values. I want those next to eachother.

 

I can do that If I change the Y and X axes, but then it shows all very thin bars and it looks crap. Could please somebody help me? Am I missing something here?

 

Rgds,

 

Felix

1 Reply

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support

    Hi x-File ,

     

    Not quite sure what you want the output to look like, you can share some sample data and the final result, not too much but please cover all situations.

     


    Best Regards

    Community Support Team _ chenwu zhu