How do I convert a line chart to a vertical line chart in Excel

  • Thread starter Thread starter Gerty
  • Start date Start date
G

Gerty

data:
yr_2007 yr_2008 yr_2009
spring 20 75 35
summer 60 25 80
fall 55 40 100

x : year
y: value of count

want convet to:
x: value of count
y: year
x
 
If I understand you correctly, a XY Scatter chart would be the more
appropriate chart. Even though it and the Line chart look similar,
the former offers a numeric x axis.

data:
yr_2007 yr_2008 yr_2009
spring 20 75 35
summer 60 25 80
fall 55 40 100

x : year
y: value of count

want convet to:
x: value of count
y: year
x
Click to expand...
Regards,

Tushar Mehta
Microsoft MVP Excel 2000-present
www.tushar-mehta.com
Excel and PowerPoint tutorials and add-ins
 
Back
Top