Newbies 3randomwords Posted November 23, 2015 Newbies Share Posted November 23, 2015 (edited) Purpose: Show total number of different items given in date range via column chart. Data entry: User enters a quantity for each item given into separate fields on record, eg. on 1/2/2015 I gave out: apples - 1, orange - 5, pears - 2, bananas - 0 I have a summary field calculating total for apples, oranges, pears and bananas which I have added as separate series on the Y axis and additional fields to limit the found count to dates within the specified range. My question: As you can see, the chart is working to a point. However, I'm unsure what I should put it the x-axis to generate the correct labels. The only workaround I have found is 'show legend', which isn't as clear. I would like the labels 'apples' 'oranges' 'pears' and 'bananas' to appear under their respective columns in the x axis. Any suggestions would be appreciated. Let me know if you need more information about the setup. Edited November 23, 2015 by 3randomwords Link to comment Share on other sites More sharing options...
comment Posted November 23, 2015 Share Posted November 23, 2015 (edited) I don't think it is a good method to have 4 separate fields for the quantities of apples, oranges, pears and bananas, as well as 4 summary fields. You should be using a child table for the quantities, where each record would hold the type and the quantity. Anyway, in your present situation you should use a calculation = "Apples¶Oranges¶Pears¶Bananas" for the X-axis data. --- P.S. IMHO, this is not a case for separate data series, either. You should use one series only and calculate the Y-axis data as = List ( sTotalOfApples ; sTotalOfOranges ; sTotalOfPears ; sTotalOfBananas ) Edited November 23, 2015 by comment Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3205 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 accountSign in
Already have an account? Sign in here.
Sign In Now