Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 21st 09, 03:38 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2009
Posts: 20
Default 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   Report Post  
Old May 21st 09, 09:14 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,489
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Superimpose one tornado chart over another ogerriz Charts and Charting in Excel 0 May 18th 09 04:46 AM
Pipeline Chart/Stacked Chart ogerriz Charts and Charting in Excel 1 April 30th 09 05:15 PM
Superimpose one chart on another Kirsten Charts and Charting in Excel 1 October 18th 08 01:41 AM
Sales Funnel Chart or Pipeline Judy[_3_] Charts and Charting in Excel 3 January 2nd 08 09:39 PM
How can I superimpose one chart over the other? sas1950 Charts and Charting in Excel 1 August 17th 05 04:49 AM


All times are GMT +1. The time now is 05:51 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017