How to add sliding values and an intercept chart

[SnipersLaww]

I came across this image with sliders for values and a chart that I want to learn how to do to add to my own calculator. I have tried learning how to do the chart but AI hasnt really been remotely helpful enough for me as it has for helping me build the rest of my calculator. The sliding values are kind of a secondary but I really want to learn how to get this chart primarily.

First image should be an image of my sheet so far and 2nd should be the image of the sheet I found that has the chart I want to try to incorporate.

[SnipersLaww]

Apparently I can only submit 1 upload per post… this is the second image.

[fpy]

@SnipersLaww

AI hasnt

what did you ask ?

me (no AI ), no sure either what’s your problem with adding a chart ?
https://books.libreoffice.org/en/CG71/CG7103-ChartsAndGraphs.html#toc5

[Regina]

The “Sliders” are called “ScrollBar” in LibreOffice. You find them in the tool “Controls”. That is not visible in the default settings, but you can add it to a toolbar or menu using Tools > Customize. You need the command “Controls” (.uno:Config) from Category “Controls”. After you have inserted it you will see a little triangle at the icon. Click on the triangle to open the float-able window of the “Controls” tool. The icon “ScrollBar” is the last one in this window.

When first time inserting such control, it is in edit mode. In edit mode you can use the control properties (from context menu) and set the minimum and maximum value in tab General. When you insert such “ScollBar” control in Calc, then you can connect it to a cell using the tab “Data” of the control properties. When you save and reopen the document, the control is no longer in edit mode but now you can drag the slider to change the value. At any time you can toggle the mode using the icon “Design Mode” in the Controls tool. It is the second icon there.

Slider.ods (16.6 KB)
The attachment has linked the “Scrollbar” control to cell A2. Changing the value in the linked cell manually, will move the slider, and the other way round, dragging the slider will change the value in the linked cell. I have put the control in front of the linked cell to indicate, that I want that the user drags the slider and not manually edits the cell value.

I do not understand your question about the chart. You should write a separate question for it.