close

I would like to combine a stacked column on one axis with a line or data
points on the other axis (or two stacked charts on two axes). I know how to
create a chart on two axes, and I have managed to build my own model with one
stacked chart and another normal bar-chart. Does anyone know how to make the
normal bar-chart into a line or stacked bar?

Janneke, I just posted that question last week and got the answer from
another person. It's possible and it's easy.

Simply select the line or column that you want to change, right click it,
then select chart type. You can then select what you want, line or column or
whatever. You did what I did. You didn't realize that you can customise
each data series. You assumed that the combinations were limited by the
examples given in Excel. You can make each set of data whatever you want.

Hope that helps.
Diana

quot;Jannekequot; wrote:

gt; I would like to combine a stacked column on one axis with a line or data
gt; points on the other axis (or two stacked charts on two axes). I know how to
gt; create a chart on two axes, and I have managed to build my own model with one
gt; stacked chart and another normal bar-chart. Does anyone know how to make the
gt; normal bar-chart into a line or stacked bar?

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()