If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Superimpose one Pipeline chart over another
Previouosly posted as Superimpose one Tornade chart over another 17/5
We are using a tornado/pipeline chart to show our sales but we would also like to show or superimpose the "perfect" pipeline to match our actual sales. Is this possible? |
#2
|
|||
|
|||
Superimpose one Pipeline chart over another
Hi,
It depends how you have created the original chart. You can place the 'perfect' pipeline on the secondary axis and the change the width of the bars. In order to do this though you would need to be creating the chart with negative values for the bars facing left. Or using formula, along with an additional series to create a floating stack. Here is an example with lines denoting a second set of data. http://www.andypope.info/ngs/ng3.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "ogerriz" wrote in message ... Previouosly posted as Superimpose one Tornade chart over another 17/5 We are using a tornado/pipeline chart to show our sales but we would also like to show or superimpose the "perfect" pipeline to match our actual sales. Is this possible? |
Thread Tools | |
Display Modes | |
|
|