Colum and line charts question - PAW - Multi line

Post Reply
mrdauduong
Posts: 52
Joined: Mon Sep 26, 2022 11:10 am
OLAP Product: Planning analytics
Version: PA 2.0.74.23
Excel Version: Excel 2016

Colum and line charts question - PAW - Multi line

Post by mrdauduong »

hi,
hope everyone well, i have a small question about colum and line charts PAW
is there anyway to have 2 more line? (right now, i can have only 1 line in field, when i try to insert another, it is not work)
i want 1 line for other cost, 1 line for interne cost and 1 line for externe cost.
thank a lot of your help ! :idea:

Cross-posted in IBM Community
https://community.ibm.com/community/use ... 4eda43146b
Last edited by mrdauduong on Mon Oct 10, 2022 7:48 am, edited 1 time in total.
User avatar
Elessar
Community Contributor
Posts: 331
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

Re: Colum and line charts question - PAW - Multi line

Post by Elessar »

Hi,

You need "Color" section in "Fields" tab for this.
Image 4.png
Image 4.png (16.99 KiB) Viewed 892 times
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
mrdauduong
Posts: 52
Joined: Mon Sep 26, 2022 11:10 am
OLAP Product: Planning analytics
Version: PA 2.0.74.23
Excel Version: Excel 2016

Re: Colum and line charts question - PAW - Multi line

Post by mrdauduong »

Elessar wrote: Mon Oct 03, 2022 3:08 pm Hi,

You need "Color" section in "Fields" tab for this.
Image 4.png

thanks you for your reponse. it work well with "line" charts

but when iam in "colum and line" charts, i can only put 1 line in this field (photo before change and photo after change)

thank
Attachments
colum and line chart question - after change.PNG
colum and line chart question - after change.PNG (57.16 KiB) Viewed 889 times
colum and line chart question - before change.png
colum and line chart question - before change.png (50.62 KiB) Viewed 889 times
User avatar
Elessar
Community Contributor
Posts: 331
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

Re: Colum and line charts question - PAW - Multi line

Post by Elessar »

You should use the "couleur" fields. One of them is for columns, one is for lines (my French is too bad)
Image 4.png
Image 4.png (53.21 KiB) Viewed 864 times
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
mrdauduong
Posts: 52
Joined: Mon Sep 26, 2022 11:10 am
OLAP Product: Planning analytics
Version: PA 2.0.74.23
Excel Version: Excel 2016

Re: Colum and line charts question - PAW - Multi line

Post by mrdauduong »

thank Elessar the for the fast repose.

Can you show me what you put in the "couleur" fields?

My probleme is my colum and my line came from the same dimension FG_account

with colum is total account and line is the detail of account

i can not do something to make it work.

thank a lot for your help!

Elessar wrote: Wed Oct 05, 2022 6:41 am You should use the "couleur" fields. One of them is for columns, one is for lines (my French is too bad)

Image 4.png
User avatar
Elessar
Community Contributor
Posts: 331
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

Re: Colum and line charts question - PAW - Multi line

Post by Elessar »

I've dragged random dimensions (Version and Cost center) to colors just to show how it works.

This depends on what you want to be split to different lines and different columns. Note that This should be different dimensions
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
Post Reply