|
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 12:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com