Given the Googe trademark in your screen shot, are you using a Charting Tool from Google or Filemaker's built in Chart tool?
No - FM charting tool - uploaded it from desktop to the forum - I assumed the Google logo was just due to them helping upload it - it's not on the original screenshot.
That's odd, since I don't see that from other posters and so needed to be sure what we were working with.
Your previous screen shot clips the X-Axis labels so I can only assume that you want a product name or ID to be used for that axis.
The chart should be set up on a layout based on LineItems, not orders.
Use a summary field that "counts" a nonblank field for your values to chart. Specify the product name or ID number for the X-Axis labels.
Select these two charing options:
Use Data from Current Found Set
Show Data Points for Groups of Records When Sorted
Then perform a find to pull up the records you want to chart and then sort them by Product name or Product ID to group them. The chart should then show one bar for each group produced by the sort.
If you are familiary with summary reports with sub summary parts, you should note the similarities here: Using a summary field for the sub totals and sorting to group the records in order to get those sub totals.
OK I just wrote a long reply but figured out the answer halfway through. The X-Axis needed to have a sum calculation on it ie "Sum (Line Items:Parts Ordered)" - and it didn't. Everything else was in place.
Many thanks for the help!
No, scratch that - that's not made a difference. It's still the same as it was before. For example the bar on the left of the graph above should be around 100,000 according to the line item figures - but it's around 10,000.
I was doing everything that was recommended above apart from the line: "Use a summary field that "counts" a nonblank field for your values to chart. Specify the product name or ID number for the X-Axis labels." Where does this summary field go? In what table/report etc...?
Define the summary field in your line items table. Base your chart layout on the line items table.
Brilliant - thanks for that. First month or so with FM - so a few things to learn!
Got any idea why Google Chrome is appending this text to every post you make here?
<div id="-chrome-auto-translate-plugin-dialog" style="opacity: 1 !important; background-image: initial !important; background-attachment: initial !important; background-origin: initial !important; background-clip: initial !important; background-color: transparent !important; position: absolute !important; top: 0px; left: 0px; overflow-x: visible !important; overflow-y: visible !important; z-index: 999999 !important; text-align: left !important; display: none; background-position: initial initial !important; background-repeat: initial initial !important; padding: 0px !important; margin: 0px !important;">
<div style="max-width: 300px !important; color: #fafafa !important; opacity: 0.8 !important; border-color: #000000 !important; border-width: 0px !important; -webkit-border-radius: 10px !important; background-color: #363636 !important; font-size: 16px !important; padding: 8px !important; overflow: visible !important; background-image: -webkit-gradient(linear, left top, right bottom, color-stop(0%, #000), color-stop(50%, #363636), color-stop(100%, #000)); z-index: 999999 !important; text-align: left !important;"> </div>
<img style="position: absolute !important; z-index: -1 !important; right: 1px !important; top: -20px !important; cursor: pointer !important; -webkit-border-radius: 20px; background-color: rgba(200, 200, 200, 0.3) !important; padding: 3px 5px 0 !important; margin: 0 !important;" onclick="document.location.href='http://translate.google.com/';" src="http://www.google.com/uds/css/small-logo.png" alt="" /></div>
That's what is producing the Google name and blank rectangle, apparently.