If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Rotate / Change axis of chart?
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
Rotate / Change axis of chart?
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 "tpeter" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|