View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
tpeter tpeter is offline
external usenet poster
 
Posts: 74
Default Rotate / Change axis of chart?

If I am understanding you correctly you want to change the x-axis to a they
y-axis. If this is what you want to do, right click on your chart and go to
source data. There is an option to go from columns or rows or you might have
to redu the source data for each series manually.

Tim

"Dave452" wrote:

Help is needed! I have a simple chart colum A are Dates and C is tempature;
Using 2003's wiszard it created a chart with temps on the Left and Dates
on/at the bottom. I had just learned that there is a limited number of colums
in 2003 so I started to revise spreadsheet. I would like to know how to
change or rotate the chart so that the dates will follow the rows (on the
Left) and Tempatures will run on Top? Is there a way in 2003 to make this
change?