Broken Y-Axis with Two sets of data

[ajedrzej]

Hi everyone,

I have two sets of data, in -- and I was wondering if it was possible to create a graph with a broken Y axis due to sets of data that make the graph larger (not being able to see the small sets of data).

As an example, you'll see that salaries has an extensive amount over the other categories, which is why I figured a broken y-axis would help. Any suggestions?

[TABLE="width: 293"]
<tbody>[TR]
[TD]Category
[/TD]
[TD]Actual
[/TD]
[TD]Budget
[/TD]
[/TR]
[TR]
[TD]Home
[/TD]
[TD="align: right"]26
[/TD]
[TD="align: right"]20
[/TD]
[/TR]
[TR]
[TD]Work
[/TD]
[TD="align: right"]125
[/TD]
[TD="align: right"]119
[/TD]
[/TR]
[TR]
[TD]Depreciation
[/TD]
[TD="align: right"]144
[/TD]
[TD="align: right"]102
[/TD]
[/TR]
[TR]
[TD]Office
[/TD]
[TD="align: right"]200
[/TD]
[TD="align: right"]155
[/TD]
[/TR]
[TR]
[TD]Misc.
[/TD]
[TD="align: right"]300
[/TD]
[TD="align: right"]60
[/TD]
[/TR]
[TR]
[TD]Other Services
[/TD]
[TD="align: right"]300
[/TD]
[TD="align: right"]250
[/TD]
[/TR]
[TR]
[TD]Salaries
[/TD]
[TD="align: right"]1,700
[/TD]
[TD="align: right"]1,800
[/TD]
[/TR]
</tbody>[/TABLE]

 

[ajedrzej]

If anyone has the same issue, this is what I ended up doing:

I created a broken Y axis graph with the primary set of data, then using the same key, I inserted the second data as a secondary graph; however, instead of columns I used a scattered graph without the lines.

If you have any questions, feel free to ask, or if you have a better way let me know.

Hope this helps. Thanks!