| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
My chart is too big
I have a spread sheet that hat 3 months of data expressed as a percentage. I
need to look at the trend over the entire three months. When i use a chart, the data is shown from 0% to 120% All of the data is between 75% and 100%. The wasted space at the end causes all the trend lines to appear flat so that I do not get the impact I want. How do I get the chart to display from 75% to 100% only? I am using a standard line chart. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
My chart is too big
Hi,
Double click the Y axis and on the Scale tab set the Maximum and Minimum to the values you want. Cheers Andy Dennis the Safety Nerd wrote: I have a spread sheet that hat 3 months of data expressed as a percentage. I need to look at the trend over the entire three months. When i use a chart, the data is shown from 0% to 120% All of the data is between 75% and 100%. The wasted space at the end causes all the trend lines to appear flat so that I do not get the impact I want. How do I get the chart to display from 75% to 100% only? I am using a standard line chart. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Activating a Chart object | Charts and Charting in Excel | |||
| Urgent Chart Assistance | Charts and Charting in Excel | |||
| Urgent Chart Questions | Excel Discussion (Misc queries) | |||
| Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
| Scrollbar on Chart Jumps to Left when Chart is Clicked | Charts and Charting in Excel | |||
Linear Mode
