Can ChartMakerPlus do Dual-Y charts?
1 Like
For your if block, make a list of pairs, for example:
Herewith a simple demo of dual axes chart:
dualYAxes.aia (12.7 KB)
Read the documentation and ocnfiguration options for additional configuration:
https://developers.google.com/chart/interactive/docs/gallery/linechart#dual-y-charts
1 Like
The seven categories work fine. When I graph the phosphates data, I get an error message "All series on a given axis must be of the same data type".
I looked at the database and do not see a problem. What should I be looking for?
Attached is a pic of the data.
1 Like
Probably these two:
when converted back from a string to a number ?? Put a zero in front > 0.04
I removed them, same error.
I deleted all of that category and added new data -same error
I moved the IF statement around so phosphates were not last, - same error
No issues here:
Oddly, the other 7 graphs work fine. I "all series on a given axis...". The horizontal axis is constant. The vertical axis changes by data. I deleted all phosphate data. entered only one value. Still error. I deleted the blocks for options on phosphates, error.
Not sure how to find the error.
Look at / Show the values in your arraytable for phosphates
Thank you - I dumped the before dataTable and tableArray2 into a Label. Found in a different group of blocks, I had misspelled a "phosphate" so the target column was responding as "not found".
Now back to my regularly scheduled fiddling. A few more things to sort out.
I have the graph part working but the make list to have two parts of the database into the array table is not. The array with phosphates is working and graphing as normal. Now trying to add "dosing" to be shown on the right axes. Do I need to build to separate dataTables and then merge them, sorta by date/time, then graph?
I provided an example for dual Y axes above:
Thank you for your example of dual Y axes,I had seen it above and been playing with it.
The example shows a graph that works. In my data set, the "Item" is my date/times. The Val1 might be Phosphates, and Val2 might be Dose. But the data is has gaps which makes the graph not correct. If I modify your example with a few more "items" to allow a test to be shown. If Val1 does not have a value on B, or Val 2 does not have a value on D, how does not need to be done?
In my data, the phosphates would be entered at different times than the dose so the there will be more items across the bottom but the data points are not on same date/time.
