Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Making the x axis range the same for multiple visuals - different data densities/frequency

Basically i have 3 line charts and one stacked bar chart. All three come from the same table and use the same variable for the x-axis. The stacked bar chart is displaying data with a different densit...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hey - I found a way to get around this issue and wanted to share it in case anyone else is looking for it.

     

    The problem is that there are no values in cells for the lower frequency data. Basically there needs to be equal number of rows for each chart that you are making, and instead of those rows without data being blank, they need to have zero's as values. The Dynamic ranging will then include those data in the range displayed for all charts. 


Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi See if this works> 

 

Example Data

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hey - I found a way to get around this issue and wanted to share it in case anyone else is looking for it.

 

The problem is that there are no values in cells for the lower frequency data. Basically there needs to be equal number of rows for each chart that you are making, and instead of those rows without data being blank, they need to have zero's as values. The Dynamic ranging will then include those data in the range displayed for all charts.