[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [libreoffice-documentation] Pivot charts in pivot tables chapter?
- Subject: Re: [libreoffice-documentation] Pivot charts in pivot tables chapter?
- From: Olivier Hallot <firstname.lastname@example.org>
- Date: Thu, 6 Jun 2019 19:34:35 -0300
- To: email@example.com
Hi Steve and Team
In case you have not stumbled up on the Help, I wrote some lines there,
and I have a demo file where you can exercise numbers.
also, for pivot tables, one recurrent user question is how to format
pivot tables cells. The solution exist but somehow hidden.
On creating a PT, several standard cell styles that are added to the
Styles list in the document. Each style is applied to part of the PT.
Pivot Table Cell Styles:
Pivot Table Categories
Pivot Table Corner
Pivot Table Field
Pivot Table Result
Pivot Table Value
Pivot Table Title
Once you customize the PT styles, then
1) you keep the cell style when updating the PT (and that is crucial
because when you direct-format a PT cell you loose its format when you
update the PT)
2) All PT's in your document will have the same look (same styles
applied to all PTs)
Em 06/06/2019 19:03, Steve Fanning escreveu:
> Hi Cathy,
> Yes, the draft version of Chapter 8 that I am working on at the moment
> describes pivot charts.
> -----Original Message----- From: Cathy Crumbley
> Sent: Thursday, June 6, 2019 9:25 PM
> To: firstname.lastname@example.org
> Subject: Re: [libreoffice-documentation] Pivot charts in pivot tables
> Just realized you are working on Chapter 8, Using Pivot Tables.
> I think that pivot tables should be discussed before pivot charts. Can I
> assume that you will include a section on pivot charts? I would like to
> refer to it in the chart chapter.
> On 5/26/2019 2:05 PM, Dave Barton wrote:
>> On 26.05.2019 18:52, Dave Barton wrote:
>>> On 26.05.2019 17:43, Steve Fanning wrote:
>>>> The 4.1 version of this document includes many figures based on a
>>>> sample spreadsheet containing sales data in various categories
>>>> (sailing, tennis, golfing) across four regions (north, east, south and
>>>> west) by five employees (Kurt, Hans, Fritz, Ute and Brigitte).
>>>> Does anybody still have a copy of the spreadsheet used previously, so
>>>> that I can maintain consistency and use it when creating new figures
>>>> for the 6.2 version of this chapter?
>>>> Steve Fanning
>>> Hi Steve,
>>> If you have access to the Nextcloud Documentation "Archive" folders the
>>> following link will get the file "Calc Guide Source Files.zip":
>>> There are three files in the zip, you want the one named "Sales
>>> If you don't have Nextcloud access write back and I will send you a
>> BTW Steve, many of us make use of the mailing list threading structure
>> to organize messages in our email clients (eg. Thunderbird).
>> Your practice of replying to an existing thread and changing the subject
>> line destroys this threading structure.
>> It would be much appreciated if you would start a new email when you
>> want to start a new subject.
>> Thanks & Regards
LibreOffice Documentation Coordinator
Rio de Janeiro - Brasil - Local Time: UTC-03:00
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
|Re: [libreoffice-documentation] Pivot charts in pivot tables chapter?||Stephen Fanning <firstname.lastname@example.org>|
- Prev by Date: Re: [libreoffice-documentation] Pivot charts in pivot tables chapter?
- Next by Date: Re: [libreoffice-documentation] Pivot charts in pivot tables chapter?
- Previous by thread: Re: [libreoffice-documentation] Pivot charts in pivot tables chapter?
- Next by thread: Re: [libreoffice-documentation] Pivot charts in pivot tables chapter?