Description: 2nd data series does not scale to secondary Y axis 2. Stock Gain color is same for all series, but HiLo is not. If the stock chart is not capable of plotting two series on different axis, functionality should be disabled Steps to Reproduce: 1.add two data 4 column series for Stock Type 2 2.change one series to Secondary axis 3.attempt to change Stock Gain Color Actual Results: 2nd series does not plot on second axis, Stock gain color changes for all series Expected Results: 2nd series on Secondary axis, separate Gain color for 2nd series. Reproducible: Always User Profile Reset: No Additional Info: Version: 7.1.1.2 (x64) / LibreOffice Community Build ID: fe0b08f4af1bacafe4c7ecc87ce55bb426164676 CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
(In reply to Ian Eales from comment #0) > Description: > 2nd data series does not scale to secondary Y axis 2. > Stock Gain color is same for all series, but HiLo is not. > > If the stock chart is not capable of plotting two series on different axis, > functionality should be disabled > > Steps to Reproduce: > 1.add two data 4 column series for Stock Type 2 > 2.change one series to Secondary axis Please explain how I can do step 2. Also, please attach an example file that shows the state after step 2.
Created attachment 179261 [details] Dual series stock chart example I frequently plot multiple series on a chart and use the 2nd access when scales are vastly different. If I have 12 months and want to plot some annual values, the categories will be 12+ rows. The monthly data includes the number of additional annual values as blank cells. The annual data has 12 blank cells and the annual values. There are two series in the charts in the file. The bar chart allows selection of each. The stock chart does not and does not plot Min/Max values
[Automated Action] NeedInfo-To-Unconfirmed
(In reply to Ian Eales from comment #2) > Created attachment 179261 [details] > Dual series stock chart example Thanks. Indeed, if I edit the stock chart and right-click the series, Format Stock Gain, change the colour, it changes it for all. I also tested on Linux with 6.3 and Windows with 3.3. Arch Linux 64-bit Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: 678446780446ae568ee8b1b814158c54ea5e393f CPU threads: 8; OS: Linux 5.17; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Jumbo Built on 1 April 2022
Created attachment 192892 [details] Duplicate Stock Type 2 Second Axis Fault This bug has been open for more than 3 years and nothing has been done. This issue is a MAJOR waste of time for people who follow the HELP instructions only to find out it does not work. What happens is the 2nd axis assignment is removed when the chart type is changed to stock and the 2 axis items are not shown. Example images of what happens follow
Created attachment 192893 [details] Step one - Chart all on Primary Y Axis
Created attachment 192894 [details] Step 2 - Annual and Rain Year moved to Sec Y Axis
Created attachment 192895 [details] Step 3 - Sec Y Axis format colors change
Created attachment 192896 [details] Step 4 - change chart to Stock - Sec Y Axis DISAPPEARS
Created attachment 192897 [details] BACK TO SQUARE ONE - change type to Bar and all Sec Y assignments are GONE The loss of Sec Y Axis assignments is likely lost when Stock is chosen for the chart type