Add a bar to a stacked column chart

[niravrph]

Hi,

I have a series of sales data (X-axis is Jan11, Feb-11, Mar-11, Apr-11) for which I generated a Stacked Column in 3D chart. Can you please tell me how I would add a NEW bar to each month? I tried but was unsuccessful. Essentially I would like this bar to serve as a "reference bar" to compare against, for each month. That is, I have sales figures from each district stacked together in one bar for January. I would now like to compare this bar to a "reference bar" that shows how district sales compared against the National sales goal.

Can you advise me please?

Thank you,
NIRAV

 

[Steve=True]

Sorry. Forgot to mention that a line is easy to add but a single column next to stacked columns are harder. Search the web for john perlitch (spelling) blog on clustered and stacked column demo or on contextures.com. Good demos