Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


Hi :)
Congrats on figuring it out and many thanks for posting the answer back to the list.  Hopefully 
when someone else needs the answer to this the archives might be more useful to answerers trying to 
help.  
Thanks and regards from 
Tom :)  





________________________________
From: Jim Thompson <jthomps6@gmail.com>
To: users@global.libreoffice.org 
Sent: Monday, 12 August 2013, 22:37
Subject: [libreoffice-users] Re: LibreOfficeCalc - secondary Y axis and getting desired data to 
appear in chart


Never mind... got it figured out.

Click on a line on the chart to make the Data Series dialog appear

   -

   Options – Align data series to
    -

      Primary Y axis … OR
      -

      Secondary Y axis

The first trick was to make the DJI line appear, by fiddling with the
Primary Y axis, then was able to align that data series with the Secondary
Y axis. Was able to get the desired chart (also changed Line display for
the DJI to make the chart easier to read).


Cheers,

Jim


On Mon, Aug 12, 2013 at 3:30 PM, Jim Thompson <jthomps6@gmail.com> wrote:

Greetings!

Using LibreOffice Calc – 4.1.0.4


  Have a fairly simple spreadsheet (just data, no formulas)

    -

    Column A – Date (e.g., 5.17 = May 17)
    -

    Columns B thru E – percentages (range between -6 and +2)
    -

    Column F – whole numbers (range between 1450 and 1600)


  Want to generate a chart (using wizard - and manual tweaking as needed)

    -

    Chart type – Line – Points and lines (easy to read)
    -

    First row as label + First column as label


  Note the initial results

    -

    DJI shows changes by date
    -

    Other numbers (percentages) are so small they are scrunched into
    virtual invisibility
    -

    OK – looks like we need 2 Y axes (one for percentages; one for DJI)


  Finish initial draft

    -

    Title – Performance of JFT IRAs + joint account
    -

    Subtitle – Compared to TRP benchmarks + DJI
    -

    X axis – date
    -

    Y axis – % lead
    -

    Display legend – Bottom


  Change primary Y axis (to display percentages)

    -

    double click on Y Axis
    -

    adjust Scale settings
    -

    uncheck Automatic for first 3 settings
     -

       Minimum -6
       -

       Maximum 2
       -

       Major interval 1
        -

    we now see interesting chart for the 4 percentage columns (by date)
    -

    (optional) drag chart to below data, pull bottom right corner to I,50
    (one page on my printer)


  Can we get DJI onto same chart by fiddling with Secondary Y axis?


  From menu bar

    -

    Insert – Axes
    -

    Secondary axes – Y axis


  Change secondary Y axis (attempting to display DJI)

    -

    double click on Secondary Y axis
    -

    adjust Scale settings
    -

    uncheck Automatic for first 3 settings
     -

       Minimum 14500
       -

       Maximum 16000
       -

       Major interval 300


  DJI line not shown. What else is required to display DJI data on same
chart?

Attached should be 2 Calc spreadsheets...

- jft_ira_performance_graph_data_DJI.ods (just the raw numbers)

- jft_ira_performance_graph_0809_DJI.ods (with half-baked chart)


Thanks for any comments or suggestions.


Jim




-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.