Chart with two axis
Hi,
I have the following data: column A: jan feb mar apr column B: 3 8 5 9 column C: 26 40 45 38 I would like to get a chart where in the horizontal axis I have the monthes and I have 4 points, connected by lines. The first point will have the value 3 in correspondence of the left vertical axis and the value 26 in correspondences of the right vertical axis. .... The fourth point will have the value 9 in correspondence of the left vertical axis and the value 38 in correspondences of the right vertical axis. How can I can do it? Thanks P |
If I understand what you are asking
you want a chart with four lines going from left to right one starting at 3 and ending at 26 and the others as listed at the base of the chart you want 4 months listed Jan through april if I assume the Jan values are the 3,8,5,9 and the April values are the 26,40,45 and 38 I would set up the spread sheet as A1=A4 as the Jan,feb,mar april put in the 3,---9 in cells B1,C1,D1,E1 and the 26-38 in B4,C4, etc in B2 enter = B1+1/3*(B4-B1) in B3 enter =B1+2/3*(B4-B1) Copy the equations in B2 and B3 and copy to C2:D3 When plotted with lines and no symbols, this will give what I think you are asking for. If not please give more information as to what you want. " wrote: Hi, I have the following data: column A: jan feb mar apr column B: 3 8 5 9 column C: 26 40 45 38 I would like to get a chart where in the horizontal axis I have the monthes and I have 4 points, connected by lines. The first point will have the value 3 in correspondence of the left vertical axis and the value 26 in correspondences of the right vertical axis. .... The fourth point will have the value 9 in correspondence of the left vertical axis and the value 38 in correspondences of the right vertical axis. How can I can do it? Thanks P |
Thank you for your reply,
Really I want a chart with a line (that connect the four points). The Jan values are 3 and 26. .... The Apr values are 9 and 38. p |
if your "Jan" in in A1
select A1:C4 (correct the range as needed.) <insert<<Chart<line [select the symbol line combination you want] nit next Make sure the columns is selected finish going through the chart wizard and putting the labels you want on the axis " wrote: Thank you for your reply, Really I want a chart with a line (that connect the four points). The Jan values are 3 and 26. .... The Apr values are 9 and 38. p |
Earlier you mentioned having two vertical axes, which highly complicates
this effort. If you have a line chart with two series on the primary axis, you can connect the pairs at each category by double clicking on either series, selecting the Options tab, and checking High-Low Lines. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ wrote: Thank you for your reply, Really I want a chart with a line (that connect the four points). The Jan values are 3 and 26. ... The Apr values are 9 and 38. p |
All times are GMT +1. The time now is 10:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com