Min and Max values in Line chart...

N

NWO

Hi.

Is there a way for me to show a certian percentage of extra space above the
max value and below the min value on a line chart without manually having to
change the setting? For example, if I have a simple line chart with values
100, 200,150,175, 95, how can I set the max left axis value to show, say, 220
and the min left axis value to show, say, 70? I wish to somehow automate
this task as I have several charts with different levels of data and I don't
want to manaully change the max and min values for each chart.

Thank you.

NWO
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Min and Max Value Changes 9
Y Axis : Dynamically Hardcode Min/Max Values? 1
Labeling on independently stacked line chart 0
Dynamic Vertical axis in a chart 2
Gantt chart duration not showing 0
Diagram with constant values in the background 3
I'm building a stacked line chart. 1

Top