Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 15
Default vertical scale on both ends of bar chart

How can I put the vertical (y) axis scale on both ends of a bar chart? I
tried putting one of the series on the secondary axis, but that just plots
the secondary axis series on top of the primary axis data and in the center
of the chart. Using Select Data Source the secondary axis series would not
move either up or down.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 563
Default vertical scale on both ends of bar chart

When you make a column chart the y-axis is generally to the left of the plot
area. If you add a seconday axis it noramlly goes to the right of the plot
area. It sounds as if you have adjusted the axis to be somewhere else. Try
making a new chart
best wishes
--
www.stfx.ca/people/bliengme


"Midjack" wrote:

How can I put the vertical (y) axis scale on both ends of a bar chart? I
tried putting one of the series on the secondary axis, but that just plots
the secondary axis series on top of the primary axis data and in the center
of the chart. Using Select Data Source the secondary axis series would not
move either up or down.

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
Area chart display ENDS before data ? Boswell Charts and Charting in Excel 0 January 1st 08 06:16 PM
How to draw chart: log scale on X axis, natural scale on y axis? Pratap D. chavan Charts and Charting in Excel 1 November 16th 06 08:03 AM
Vertical line in a histogram (vertical bar chart) AdamCPTD Excel Discussion (Misc queries) 0 July 13th 06 09:43 PM
Chart shows all month-ends as 30th Alan Z. Scharf Charts and Charting in Excel 3 May 13th 06 05:07 PM
Format Axis; Scale Tab; "Value Axis Crosses At" ends with preposit Pedant Charts and Charting in Excel 1 August 29th 05 03:50 AM


All times are GMT +1. The time now is 07:19 AM.

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"