8 Replies Latest reply on Feb 11, 2019 4:14 AM by Diego Parker

Reference Bars on Bar Graph from something other than y=0

David Katz Feb 10, 2019 10:39 AM

Hi All --

I haven't yet found this particular question already in the forums, although there are some similar to it. My problem is that I want all of my bars to originate at some number less than zero (for instance, -30 in the picture below), with the bar extending upward until it hits the value of the particular mark.

Instead, all bars originate from y=0 and extend up or down accordingly, and nothing I do in the Format Axis box changes this. Is there a clever way around this, or perhaps something simple I'm missing?

Thanks and regards,

David

1. Re: Reference Bars on Bar Graph from something other than y=0

David Katz Feb 10, 2019 10:42 AM (in response to David Katz)
Sorry, here's a better image.

Regards,
David

bar_graph.PNG 82.4 KB
Like Show 0 Likes(0)

Actions
2. Re: Reference Bars on Bar Graph from something other than y=0

Diego Parker Feb 10, 2019 11:07 AM (in response to David Katz)

Hey David,

As your data is negative, I believe what you have to do is to change the axis end, not the start. I also changed the tick mark.

I hope this helps. If does, please mark it as helpful or correct so other users can find the answer.

Best,
Diego
Like Show 0 Likes(0)

Actions
3. Re: Reference Bars on Bar Graph from something other than y=0

David Katz Feb 10, 2019 11:37 AM (in response to Diego Parker)
Hi, Diego -

Thank you for the ideas. However, they don't seem to resolve the problem I'm having.

I created a packaged workbook (Desktop 2018.3) that simplifies things. Essentially, I'd like for all the bars to start at -35 and proceed upward from there until they hit the value of the actual mark.

Thanks and regards,
David

BarGraph.twbx 11.0 KB
Like Show 0 Likes(0)

Actions
4. Re: Reference Bars on Bar Graph from something other than y=0

Diego Parker Feb 10, 2019 12:57 PM (in response to David Katz)
Hi David,

I wasn't able to come with a super easy solution, therefore I had to do a small workaround.

Hope this helps. If you have any questions regarding my approach do not hesitate on asking.

If this is helpful or answers your questions, please mark it as helpful/correct so other users can refer to it.

Best,
Diego

BarGraph.twbx 8.4 KB
Like Show 0 Likes(0)

Actions
5. Re: Reference Bars on Bar Graph from something other than y=0

David Katz Feb 10, 2019 3:08 PM (in response to Diego Parker)

Thanks for giving this another try, Diego. Unfortunately, it doesn't match what I need, but I certainly appreciate the effort!

Regards,
David
Like Show 0 Likes(0)

Actions
6. Re: Reference Bars on Bar Graph from something other than y=0

Adolfo Hernandez Feb 10, 2019 4:42 PM (in response to David Katz)
Hello David,

Please check my solution, I think that's what you are looking for. If so, please mark this question as answered. Thanks!

Adolfo

PS: Please note that the chart is not a bar chart, is a Gantt bar emulating a bar chart.

BarGraph - Proposed Solution.twbx 9.5 KB
Like Show 0 Likes(0)

Actions
7. Re: Reference Bars on Bar Graph from something other than y=0

David Katz Feb 10, 2019 5:24 PM (in response to Adolfo Hernandez)

Thanks, Adolfo! It's a shame that this isn't supported natively in the Bar Chart, but I appreciate the creative solution. For graphs with lots of marks, the extra calculation involved would probably be prohibitive for this approach, but it's a good demonstration of how one could provide this representation.

Regards,
David
Like Show 1 Likes(1)

Actions
8. Re: Reference Bars on Bar Graph from something other than y=0

Diego Parker Feb 11, 2019 4:14 AM (in response to David Katz)

Sorry David! I missed the bit that you wanted them going into the same direction. I think probably because that was a bit counterintuitive for me.

Glad you found an answer!

Best,
Diego
Like Show 0 Likes(0)

Actions