Change Bar Widths of Horizontal Bar Chart

Ant T
Ant T Member
in Archive

Is there a way to increase the width of the bars of a horizontal bar chart? Even at 100+% width settings they're still really thin, causing the text labels to overlap, and I need all the labels so I can't simply hid the overlapped ones. There's so much wasted white space it's ridiculous to have the bars be this thin and 70% of the chart be empty space. See attachment for example.

 

Thank you!

Comments

  • ST_-Superman-_
    ST_-Superman-_ Coach

    That does look odd.  Do you have a lot of series with null values?  My guess is that you do, and so the chart is saving space for those series.  I would try filtering out those null values and see if that fixes your issue.


    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
  • Ant T
    Ant T Member

    Unfortunately there are no null values in my series. My horizontal bar charts have always looked like this for many visualizations across various data sets and filters. Even if I reduce filters to allow more series values, the bars will only become thinner and more cramped while the white space between them remains the same. 

  • ST_-Superman-_
    ST_-Superman-_ Coach

    would you mind sharing a screen shot of your analyzer?

     

    It looks like you have either a user or location id as your y axis, the % of print jobs as your value and then the name of the printer as a series.  

     

    In this case, for location 201805, it is saving a spot for every printer name that exists whether that user or location has used the printer or not.  That is the reason for the white space.  have you considered a stacked 100% chart?  Or even just a stacked bar chart?  I think the grouped bar chart is the cause for the white space.


    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
  • Ant T
    Ant T Member

    The y-axis is a date field (yearMonth) and all the products for that yearmonth are shown, so there wouldn't be other products in that yearmonth to save a space for, unless you're saying it's holding a spot for EVERY existing product across any timeframe. This might be possible, but there are hundreds of products and I'm I don think this is reflected in the white space. It's an interested theory though and could be contributing to the issue somehow. I may switch back to a stacked bar later if I can't find a solution for this. The data isn't represented as a comparison of monthly totals, so a stacked bar isn't the best visualization. 

  • ST_-Superman-_
    ST_-Superman-_ Coach

    What happens if you filter the card for a single yearMonth?  Does the white space go away?


    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
  • Ant T
    Ant T Member

    It does go away. In the screenshot the y-axis date is beneathe the set of bars but when viewing only one month the date is centered within the set of bars, leaving no white space below.

  • Ant T
    Ant T Member

    I see the pattern you're saying now. As I add more months, which in turn adds more products, the white space below the last bar of any particular month grows. I always just thought the bars were only getting thinner but the white space actually grows as well. If I use the y axis label as a reference point for the "middle" of that month's set of bars, I can see that there is more and more white space above the "middle", meaning the overall range of bars for that month is being filled with more white spaces/"invisible" bars. It seems like a flaw in DOMO's visualization to handle a series this way, although I understand the logic behind it. A stacked bar doesn't represent the data the way I need so I may have to accept the white spaces for now unless there's a way to remove it.

  • ST_-Superman-_
    ST_-Superman-_ Coach

    You could create a beastmode that would bucket these products into larger groups.

    You could always then allow the user to drill down to a view that provides the actual product name.

     

    something like

     

    case when `Product_Name` like '%PageWide%' then 'PageWide'

    when `Product_Name` like 'LaserJet%' then 'LaserJet'

    when `Product_Name` like '%HP%' then 'HP'

    else 'Other'

    end

     

    Using this field as your series would give each month a max of 4 bars: PageWide, LaserJet, HP, and Other


    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
  • Ant T
    Ant T Member

    That's a good idea and may be applicable to a few other cards I have. For this specific chart however, we need to display all individual product names for our clients and show them all three months of a particular quarter. If I were still using screenshots for presentations, I could view them one month at a time and take 3 screenshots, but now I'm using the DOMO PowerPoint plugin to directly export cards to specific slides on a presentation, so the final desired visualization has to be accomplished at the card level prior to export.

This discussion has been closed.

Categories