Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default automatically increment y-axis daily

I have a bar Chart running showing calendar days available to a 'point' and I
have to increment this manually so that it shows from the current date. Does
anyone know how this (Y-axis) can be incremented daily automatically?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default automatically increment y-axis daily

Hi,

See here for details on dynamic ranges.
http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/ne...rts/index.html

Cheers
Andy

Peter Dacre wrote:
I have a bar Chart running showing calendar days available to a 'point' and I
have to increment this manually so that it shows from the current date. Does
anyone know how this (Y-axis) can be incremented daily automatically?


--

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
how do i automatically update % figures daily JohnM Excel Discussion (Misc queries) 5 September 11th 06 05:52 PM
shift Y axis Terry Charts and Charting in Excel 7 June 25th 06 06:18 PM
how can I have a secondary axis bar not covering the primary axis Luiz C Bigas Charts and Charting in Excel 1 April 5th 06 05:57 PM
Is numeric "Series Axis" possible? fendwick Charts and Charting in Excel 2 September 13th 05 06:47 PM
increment cell value automatically Gummy Excel Worksheet Functions 0 November 5th 04 10:30 PM


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