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

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
 
T

Tushar Mehta

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

create chart line 2
Display Horizontal and Vertical Line In Area Chart (Excel 2007) 2
Make a mekko chart in Excel 2007 in three easy Steps 1
Vertical line in stock chart 1
Creating a total cost chart where a component cost is a step cost 0
How to manually switch data from x axis to y axis in line chart? 1
Drawing points on a three colored chart region 1
Plotting a current Date Vertical Line 1

Top