Here's the two charts, Copy/Pasted on top of each other. I have mis-aligned them vertically so you can see the effect....
And here's the same thing... all i've done is change the data on the 'Y' axis to be another field....
The X axis has 'shrunk' itself. The boundary box is the same, the bars are not the same width. The space in between them is not even.
If I stretch the boundary box, it can be made to fit over the top 'approximately' but it is a real bodge.
I'm not sure what I'm doing wrong....
I have used an 'IF' statement to set the Calc field to '0' if there is no SUM data, but that doesn't work.
I've tried setting it to '50,000' if there's no SUM data, but that doesn't work, either.
I thought perhaps that there was no data in the field, it would resize the scale.
Would a "stacked bar chart" work for you? the results would not be identical to what you are attempting here, but close and any scale changes would not result in a misalignment.
Thanks for your post - 'Shaun' at FileMaker USA told me today that I should ask this here and wait for you to post; because you'd be able to solve it! So no pressure...
A stacked chart doesn't really work for me in this instance, no. I primarily use this layering in dashboard data scenarios where targets are shown on a factory production floor. So there's the 'Target' underneath and then the actual live data 'grows' on top of it. It's also a really nice way to show the same sort of thing in sales data with transparency effects.
Any ideas? Is there something in the actual number data that defines the sizing of the columns and gaps...? There's like some chart-kerning going on and i can't see how to control it!
Nobody else have an insight into this?
I will pay a FileMaker developer to provide information that fixes this!
Do both charts have all the same options specified except for the Y-series data?
I don't quite see why the second chart is a smaller size, but there are resize handles that should allow you to stretch the lower to match the upper, but I am doubtful that this will be a very effective design option for you as FileMaker doesn't give you a lot of direct control over the x axis scale.
On the other hand there alternative approaches to bar charts, from java scripted web viewers to the "old school" methods that we used to use before we had chart objects, such as a series of repeating fields that recreate the "bars" of the chart. This is a lot more design work to set up, but because each bar is a different layout object, you have much more control over how such multiple charts align with each other.
Yes, all the other options are exactly the same. It's been copy/pasted and then the Y changed.
Altering the size of the chart via the handles just stretches the chart. So the columns grow wider, the gaps are also wider. This means you can never really get them to line up properly. I have done this with one data set that has just 2 months data (this and last months) on the chart, on top. So they sort of line up but you can't see the other months 'going out' exponentially.
I suppose I could have one chart per month, and then align those months etc. together.
From what FM Support said, the answer was available somewhere!
Thanks for your help with the suggestions.