The one shown below is a stacked bar chart of expenses and a 2-D two axis chart of the income (as a bar), balance (as a line), one blank column (as a bar). The min and max Y axis setting for the one chart and the Y1 axis setting for the combo chart must be set manually and the same. It takes a good bit of work to get the bar widths matching and everything lined up properly and you turn off all the axis lines and labels on one chart. If you are looking for a trick to do it in Numbers, you can create two charts that overlap, one on top of the other.
I could get stacked bars or single bars but not both and I could get some kind of screwed up mess with wide bars in front of narrow bars but I couldn't figure out how to get the mix. I tried to follow some directions I found but by version of Excel (16.48 for Mac) doesn't work the same as what was being explained and the controls were not the same. I was curious to see how this worked in Excel.
0 kommentar(er)
