Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Need graph to automatically adjust in size

Received Response
41
Views
3
Comments
Matt W
Matt W Rank 2 - Community Beginner

Hi,

We have an analysis where a table of data is displayed on the left side of the screen and a corresponding horizontal stacked bar chart is displayed on the right-hand side of the screen.

The table can have up to 40 rows of data which equates to 40 bars in the corresponding chart. We are finding that the size of each individual bar in the chart will either shrink or grow to fill the size of the chart "container" (set by the pixel height/width in the analysis editor).

Is there a way that the chart size can be dynamic so that the bars in the chart do not change their size? Ideally, we want the bars to be about 1cm wide, regardless of how many bars comprise the chart. The fewer rows of data in the table, the larger the bars in the corresponding chart.

Thanks in advance!

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Short answer: No.

    Longer answer: No. The real-estate the graph can utilize is fixed. Same thing's the case for DV / VA by the way. You size the canvas and the charting engine fills it.

    pastedImage_0.png

  • Matt W
    Matt W Rank 2 - Community Beginner

    Thanks @Christian Berg Appreciate the answer and the additional context... too bad there isn't an option to expand/collapse the graph container dynamically. I'm sure that's a feature that would have both pros and cons.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Exactly. If you have the areas size dynamically then IMMEDIATELY the "let's print everything" mafia will scream because they don't have something which fits nicely and in a predictable and repeatable fashion on their sheet of paper.