Horizontal Labels for Charting Data in One Record

[laguna92651]

I am doing a column chart with 6 fields that are in the same record, how can I give each field, bar, a different label on the horizontal axis?

Lets say I have sales for 6 years in the same record.

2009  $900

2010 $1000

2011 $1100

2012 $1200

2013 $1300

2014 $1400

I would like to label each of the amounts with the associated year.

[comment]

First thing: you should not have sales for 6 years in the same record. They should be in 6 separate records, with fields for Year and Amount.

Next, you did not tell us where are the labels supposed to come from. Surely you don't have a field named "2009"?

Edited October 30, 2015 by comment

[laguna92651]

I was originally going to set up another table, but in this application it just seemed easier to put the fields in the same record. There shouldn't be that many records in the database and there won't be more than 6 years. It was just easier to move fields around on the screen to configure 

The labels will be the contents of the field year 0, year 1, year 2, year 3, year 4 and year 5.

[comment]

it just seemed easier to put the fields in the same record.

It's not easier. You have to do everything 6 times. And there are things you cannot do at all with this arrangement.

Anyway, if you have fields for the labels, you just need to list them in a return-separated list (same as the values):

List ( year 0 ; year 1 ; year 2 ; year 3 ; year 4 ; year 5 )

 

[laguna92651]

I placed the List (year 0; year 1 ; year 2 ; year 3 ; year 4 ; year 5 ; year 6) in the Data entry for the x-axis and it looks like it is showing up as a label for one of the Y series, all 6 years are one label for one data series. For the y axis, I have 6 series, one for each year. Thanks for the help.

[comment]

For the y axis, I have 6 series, one for each year.

I am not sure I follow your description fully, but that doesn't sound right. If you have 6 values, one for each year, then you have only one data series - and it should be calculated the same way as the labels, i.e:

List ( Value 0 ; Value 1 ; Value 2 ; Value 3 ; Value 4 ; Value 5 )

 

[laguna92651]

Forgot to select "delimited data", thanks. You mentioned "that there are things you cannot do at all with this arrangement," what are some of those things?

[comment]

23 hours ago, laguna92651 said:

You mentioned "that there are things you cannot do at all with this arrangement," what are some of those things?

For example, you cannot produce a report like this:

2012
• Product B: 131
• Product A: 119
• Product C: 105
2013
• Product A: 142
• Product B: 129
• Product C: 112
2014
• Product A: 149
• Product C: 132
• Product B: 127

[laguna92651]

Thanks for the input, I appreciate your help. Al