| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart problem: values in column A don't show as labels on x-axis
The data in column A in the table I want to use for a chart contains numeric values: 2000 - 2001 - 2002 - ... In the chart these don't show as labels for the x-axis, but as a series of data in the chart. Any way around this without changing all the values in coumn A into text? -- digicat ------------------------------------------------------------------------ digicat's Profile: http://www.excelforum.com/member.php...o&userid=14920 View this thread: http://www.excelforum.com/showthread...hreadid=499471 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Chart problem: values in column A don't show as labels on x-axis
When the x-categories can be mistaken for numbers, that is what Excel does.
Try removing the heading from the top of that column (but not from the y-values); select the heading and the data to make the chart. Excel should now find x-category values best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "digicat" wrote in message ... The data in column A in the table I want to use for a chart contains numeric values: 2000 - 2001 - 2002 - ... In the chart these don't show as labels for the x-axis, but as a series of data in the chart. Any way around this without changing all the values in coumn A into text? -- digicat ------------------------------------------------------------------------ digicat's Profile: http://www.excelforum.com/member.php...o&userid=14920 View this thread: http://www.excelforum.com/showthread...hreadid=499471 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to put x axis values in the chart instead of x axis labels | Charts and Charting in Excel | |||
| In Excel how do I label the axis of a chart with 2 sets of labels | Charts and Charting in Excel | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
| How do I eliminate duplicate values on y axis of an Excel chart? | Charts and Charting in Excel | |||
| Column Chart with 2 values in each column | Charts and Charting in Excel | |||
Hybrid Mode
