Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Phil Hageman
 
Posts: n/a
Default Secondary Axis Without Data Points?

Is it possible to have two Y Axes (one left and one right) with only one data
series?

Thanks,
Phil
  #2   Report Post  
Bernard Liengme
 
Posts: n/a
Default

Hi Phil,
Yes but you need to cheat!
Make chart in normal way. Now select the range of cells with the y-values
and use Copy command; click on chart and use Paste. Now you have two
identical series. Right click on the new data series in the chart; from
popup menu use Format Data Series; on Axis tab specify Secondary Axis and on
Pattern tab specify No makers and NO line (make second series invisible)

Hope this helps
best wishes
Bernard

"Phil Hageman" wrote in message
...
Is it possible to have two Y Axes (one left and one right) with only one
data
series?

Thanks,
Phil



  #3   Report Post  
Andy Pope
 
Posts: n/a
Default

Hi Phil,

You need 2 data series in order to use a secondary axis.
That said the second data series can be formatted such that it does not
appear. If you use a copy of the original data the 2 Y axis will have
the same min and max values.

Cheers
Andy

Phil Hageman wrote:

Is it possible to have two Y Axes (one left and one right) with only one data
series?

Thanks,
Phil


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #4   Report Post  
Phil Hageman
 
Posts: n/a
Default

Bernard,

Thanks for your reply - works as desired.

Phil

"Bernard Liengme" wrote:

Hi Phil,
Yes but you need to cheat!
Make chart in normal way. Now select the range of cells with the y-values
and use Copy command; click on chart and use Paste. Now you have two
identical series. Right click on the new data series in the chart; from
popup menu use Format Data Series; on Axis tab specify Secondary Axis and on
Pattern tab specify No makers and NO line (make second series invisible)

Hope this helps
best wishes
Bernard

"Phil Hageman" wrote in message
...
Is it possible to have two Y Axes (one left and one right) with only one
data
series?

Thanks,
Phil




  #5   Report Post  
Phil Hageman
 
Posts: n/a
Default

Thanks for your reply Andy - works fine.

"Andy Pope" wrote:

Hi Phil,

You need 2 data series in order to use a secondary axis.
That said the second data series can be formatted such that it does not
appear. If you use a copy of the original data the 2 Y axis will have
the same min and max values.

Cheers
Andy

Phil Hageman wrote:

Is it possible to have two Y Axes (one left and one right) with only one data
series?

Thanks,
Phil


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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
why can I not format a secondary axis in excel x? mackie99 Charts and Charting in Excel 5 April 5th 23 02:47 PM
Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another John Smith Charts and Charting in Excel 7 December 21st 04 09:26 PM
Display negative data points differently. MRN Charts and Charting in Excel 1 December 19th 04 11:01 PM
Secondary Axis? AlCamp Charts and Charting in Excel 3 December 4th 04 03:28 PM
Problems with true value on secondary Y axis NeedHelp Charts and Charting in Excel 1 December 3rd 04 06:56 PM


All times are GMT +1. The time now is 09:28 PM.

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

About Us

"It's about Microsoft Excel"