Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default How do I change value of Y axis on graph

Am creating a basic chart for the first time.I need my Y axis to be from 1 to
20.

  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default How do I change value of Y axis on graph

Hi,

Double click the Y axis. On the scale tab enter the required Maximum value.

Cheers
Andy

Al luvs cats wrote:
Am creating a basic chart for the first time.I need my Y axis to be from 1 to
20.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default How do I change value of Y axis on graph

Thanks so much!!!

"Andy Pope" wrote:

Hi,

Double click the Y axis. On the scale tab enter the required Maximum value.

Cheers
Andy

Al luvs cats wrote:
Am creating a basic chart for the first time.I need my Y axis to be from 1 to
20.


--

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
can't change how data on 2nd axis is being displayed Rebekah Charts and Charting in Excel 1 May 4th 05 02:51 PM
How do I change the category axis number formatting in a Pivot Ch. Cultcab Charts and Charting in Excel 0 April 19th 05 12:26 AM
How do I change background colors between secondary y axis lines? myhounds Charts and Charting in Excel 2 March 28th 05 01:11 AM
How do I change the scale of the catagory axis? amcmaster Charts and Charting in Excel 1 March 2nd 05 04:46 PM
How do I add a second axis to a graph with 2 data series? Laura Charts and Charting in Excel 2 February 2nd 05 03:30 PM


All times are GMT +1. The time now is 10:17 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"