Rotate / Change axis of chart?

  • Thread starter Thread starter Dave452
  • Start date Start date
D

Dave452

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?
 
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
 
Thank you Tim for the ideas, I'm using 2003 and this is the redo because I
could not show 365 colums in my sheet1 of the weather study so I redid the
format using a row per day. Now I had to redo the chart to run vertical
rather than Horizontal. I am now trying to use the date column in the chart
to be positioned at the left-end of the "plot-area" rather than at the same
spot that shows the value! I'll take suggestions!
Thanks again Tim...Dave452
 
Back
Top