I have the most infuriating problem with graphs in Numbers, and I'm starting to suspect it's impossible to do what I want to do... but I thought I'd ask before giving up.
Okay, I have some balance sheet data... for five years, such that the following equalities are observed:
2002: A+B = C+D+E
2003: A+B = C+D+E
2004: A+B = C+D+E
yada yada yada
Now, I want to make one graph that includes series of stacked bars.
That is, for category '2002' I want two stacked bars, one that shows A+B, and one that shows C+D+E, side by side, to show how the sum is equal.
I can do it in Excel by manually fiddling the Series data, but can it be done in Numbers? I've driven myself half mad trying to figure this out, dragging and dropping cells around... but all I succeed in doing is producing a stacked bar of A+B+C+D+E which is exactly what I don't want.
Hopefully somebody's tried to do this already, and hopefully hey've had more success than I've had. Care to share?
Okay, I have some balance sheet data... for five years, such that the following equalities are observed:
2002: A+B = C+D+E
2003: A+B = C+D+E
2004: A+B = C+D+E
yada yada yada
Now, I want to make one graph that includes series of stacked bars.
That is, for category '2002' I want two stacked bars, one that shows A+B, and one that shows C+D+E, side by side, to show how the sum is equal.
I can do it in Excel by manually fiddling the Series data, but can it be done in Numbers? I've driven myself half mad trying to figure this out, dragging and dropping cells around... but all I succeed in doing is producing a stacked bar of A+B+C+D+E which is exactly what I don't want.
Hopefully somebody's tried to do this already, and hopefully hey've had more success than I've had. Care to share?