Jump to content

Horizontal Labels for Charting Data in One Record


laguna92651

This topic is 3046 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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 by comment
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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 )

 

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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 )

 

Link to comment
Share on other sites

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

  • Like 1
Link to comment
Share on other sites

This topic is 3046 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.