| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
2 Axes, same scale wanted
Hi
Is it possible to set my second y axis so that the scale is identical to the first y axis. (My chart needs to have 2 axes as one plots daily values and one plots annual) but I find that excel automatically assigns diferent scales to each? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
2 Axes, same scale wanted
This same reference should apply to dual axis charts. You can apply scales
to both primary and secondary axes using worksheet cells via Jon's explanation below. http://peltiertech.com/Excel/Charts/...nkToSheet.html -- John Mansfield http://cellmatrix.net "jonny" wrote: Hi Is it possible to set my second y axis so that the scale is identical to the first y axis. (My chart needs to have 2 axes as one plots daily values and one plots annual) but I find that excel automatically assigns diferent scales to each? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adjusting the y axes on 2-axes line graphs | Charts and Charting in Excel | |||
| Just wanted to say thanks! | Excel Discussion (Misc queries) | |||
| How do I scale excel chart axes from vb? | Charts and Charting in Excel | |||
| Locking gridlines to be square - axes to same scale ? | Charts and Charting in Excel | |||
| Change Axes Scale Dynamically | Charts and Charting in Excel | |||
Hybrid Mode
