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!
|