| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Axis titles in Excel 2007
Hi,
I've created a chart from a spreadsheet in Excel 2007. I want the horizontal axis to show the year (1995 to 2002), currently it just shows 1,2,3,4,5,6 &7. How do I achieve this? Thanks Tom |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change Axis titles in Excel 2007
You need to make a table like this
year data 1999 101 2000 102 2001 103 2002 104 2003 105 2004 106 but delete the header year Make chart for this data best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "tom_the-confused" wrote in message ... Hi, I've created a chart from a spreadsheet in Excel 2007. I want the horizontal axis to show the year (1995 to 2002), currently it just shows 1,2,3,4,5,6 &7. How do I achieve this? Thanks Tom |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change Axis titles in Excel 2007
Thanks Bernard,
But that's the layout of the spreadsheet I've created. Tom "Bernard Liengme" wrote: You need to make a table like this year data 1999 101 2000 102 2001 103 2002 104 2003 105 2004 106 but delete the header year Make chart for this data best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "tom_the-confused" wrote in message ... Hi, I've created a chart from a spreadsheet in Excel 2007. I want the horizontal axis to show the year (1995 to 2002), currently it just shows 1,2,3,4,5,6 &7. How do I achieve this? Thanks Tom |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change Axis titles in Excel 2007
What kind of chart is it?
Click on the series, and read the formula bar. It should read something like this (correct for actual sheet name and ranges): =SERIES(Sheet1!$B$1,Sheet1!$A$2:$A$8,Sheet1!$B$2:$ B$8,1) If not, Excel didn't correctly guess what you wanted to plot. You can click the Edit Data button on the first chart tab, then change the various ranges indicated for series data and category labels. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "tom_the-confused" wrote in message ... Thanks Bernard, But that's the layout of the spreadsheet I've created. Tom "Bernard Liengme" wrote: You need to make a table like this year data 1999 101 2000 102 2001 103 2002 104 2003 105 2004 106 but delete the header year Make chart for this data best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "tom_the-confused" wrote in message ... Hi, I've created a chart from a spreadsheet in Excel 2007. I want the horizontal axis to show the year (1995 to 2002), currently it just shows 1,2,3,4,5,6 &7. How do I achieve this? Thanks Tom |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change Axis titles in Excel 2007
Hi
Thanks Jon - the answer lay in the edit data button and then edit the horizontal axis. Tom "Jon Peltier" wrote: What kind of chart is it? Click on the series, and read the formula bar. It should read something like this (correct for actual sheet name and ranges): =SERIES(Sheet1!$B$1,Sheet1!$A$2:$A$8,Sheet1!$B$2:$ B$8,1) If not, Excel didn't correctly guess what you wanted to plot. You can click the Edit Data button on the first chart tab, then change the various ranges indicated for series data and category labels. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "tom_the-confused" wrote in message ... Thanks Bernard, But that's the layout of the spreadsheet I've created. Tom "Bernard Liengme" wrote: You need to make a table like this year data 1999 101 2000 102 2001 103 2002 104 2003 105 2004 106 but delete the header year Make chart for this data best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "tom_the-confused" wrote in message ... Hi, I've created a chart from a spreadsheet in Excel 2007. I want the horizontal axis to show the year (1995 to 2002), currently it just shows 1,2,3,4,5,6 &7. How do I achieve this? Thanks Tom |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2007 edit chart titles | Charts and Charting in Excel | |||
| excel 2007 edit chart titles | Charts and Charting in Excel | |||
| Rotate axis titles in Excel | Excel Discussion (Misc queries) | |||
| axis titles in Excel charts | Charts and Charting in Excel | |||
| resize chart or axis titles in Excel | Charts and Charting in Excel | |||
Linear Mode
