If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|