LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 30
Default Dynamic X-Axis in Chart

Hi,

I know there is a lot of content out there about dynamic range in charts but
as far as I can see my problem is not covered yet (forgive me when I'm wrong).

Problem:
- I have one value to display in a chart, e.g. value=0.5 (cell A1)
- the boundaries of the x-axis should be determined by the user, e.g. min=0
(cell B1) and max=1 (cell C1)

Question:
How can I create a dynamic chart without the user need to go into the chart
menu "Format Axis = Scale" ?

Thanks for help!
 
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
Dynamic Range Name For Axis? RayportingMonkey Charts and Charting in Excel 1 August 30th 07 11:50 PM
chart with dynamic x axis name Charts and Charting in Excel 1 May 4th 06 03:42 PM
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM
Dynamic Bar Chart Category Axis Problem Richard Charts and Charting in Excel 1 September 13th 05 09:51 AM
graphs with dynamic x-y axis confused Charts and Charting in Excel 2 June 9th 05 05:13 AM


All times are GMT +1. The time now is 02:38 AM.

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

About Us

"It's about Microsoft Excel"