View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Hannes Hannes is offline
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!