Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
data labels in charts
This is a probably one of the simplest questions but I'm just starting to
chart again. I have entered a category title "year" in cell A1 and entered from 1995 to 2000 from A2 to A7 that I want to appear on the horizontal axis. I have entered a title in B1(unemployed) and 5 values B2 to B7 directly below. When I choose a "column" chart my vertical axis appears correctly but the horizontal axis does not include the years as labels. The labels that appear are the numbers 1 to 6 instead of 1995 to 2000. How do I make the chart pick up the data labels from column "A"? I used to make charts a long time ago and I never remembered this being a problem. Thanks anyone. -- Carol |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
data labels in charts
Hi,
Simplest thing is to remove the text 'Year' from A1. The chart you have created contains 2 series. Where the first series is the years and the second the Unemployed values. Cheers Andy Carol Rutledge wrote: This is a probably one of the simplest questions but I'm just starting to chart again. I have entered a category title "year" in cell A1 and entered from 1995 to 2000 from A2 to A7 that I want to appear on the horizontal axis. I have entered a title in B1(unemployed) and 5 values B2 to B7 directly below. When I choose a "column" chart my vertical axis appears correctly but the horizontal axis does not include the years as labels. The labels that appear are the numbers 1 to 6 instead of 1995 to 2000. How do I make the chart pick up the data labels from column "A"? I used to make charts a long time ago and I never remembered this being a problem. Thanks anyone. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data labels on charts | Excel Discussion (Misc queries) | |||
Data Labels on charts | Charts and Charting in Excel | |||
Adding data labels to charts | Excel Discussion (Misc queries) | |||
There is a bug in formatting charts data labels. | Excel Worksheet Functions | |||
Help with pivot charts and data labels | Charts and Charting in Excel |