[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