Chart - Custom Stacked Bar with Line

A

ak_edm

Hi,

I've been looking at some techniques for custom charts written up by Jon
Peltier, but I'm still confused mainly from lack of experience.

|
|
|
|
|
|
|

Above is a four week stacked-column chart with the first series of data
invisible. This makes the columns appear to float. I know how to do this.

Assume the bottom of column 1 is $0. What I'm charting is four weeks of
income broken down into weeks. By stacking the data from the previous week
into the successive week, and then making that series invisible, I'm able to
give a total income for each week and also keep a visual running total with a
series of "steps". It's nice.

My problem is that this income is set against goal. So I want the chart to
answer "Are we making goal?" Imagine a diagonal goal-line from column 1 to
column 4 that the bars may or may not rise above depending on income vs goal,
or an area fill in the same manner.

So how do I do it? I feel I'm close, but I lack the terminology or
something to complete it.

- Eric
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top