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
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