Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Visualization
Created by Guest
Created on Jul 29, 2016

Add line per bar based on expression in bar chart

Currently it is only possible to add a line in a bar chart which is shown over the full width. It would be nice to be able to draw a line in/at every bar. The the height of the line can be set with an expression.

 

Examples:
I've a stacked bar with the number of sales and the expected number of sales stacked for different regions. For every region I would like to add a line in the bar chart at the height of the target for that region.

  • Attach files
  • Guest
    Reply
    |
    Aug 17, 2016

    Indeed, I want to visualize the target in the related bar. A side by side bar isn't feasible when for example I use a color for different months while the target is on a yearly bases. This is also a reason why a combination chart doesn't work, since then it is not possible to color by month. So I want to use this in a bar chart since they are more flexible than the line charts.

  • Admin
    Niklas Amberntsson
    Reply
    |
    Aug 17, 2016

    Wim and Andrew, to make sure I understand this correctly: you would like to visualize for example sales vs target per product category, and instead of using side by side bars in a barchart you would like to visualize the target per category as a line?


    I assume you considered (and possibly ruled out?) using a combination chart? I have heard what I think is a similar request which is expressed as "visualize sales vs targets" in a combination chart with the target shown as a dot or other symbol instead of a full connected line.

  • Guest
    Reply
    |
    Jul 31, 2016

    yes the ability to set a horizontal line based upon an expression for each unique category value in a bar chart would be great - we don't usually apply a single target (horzontal line) across all of our unique category values.