Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Superimpose one chart on another | Charts and Charting in Excel | |||
Superimpose one tornado chart over another | Charts and Charting in Excel | |||
Pipeline Chart/Stacked Chart | Charts and Charting in Excel | |||
Sales Funnel Chart or Pipeline | Charts and Charting in Excel | |||
How can I superimpose one chart over the other? | Charts and Charting in Excel |