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 !
Cross-posted in IBM Community
https://community.ibm.com/community/use ... 4eda43146b
Colum and line charts question - PAW - Multi line
-
- 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
Last edited by mrdauduong on Mon Oct 10, 2022 7:48 am, edited 1 time in total.
- 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
Hi,
You need "Color" section in "Fields" tab for this.
You need "Color" section in "Fields" tab for this.
Best regards, Alexander Dvoynev
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
-
- 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
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 (57.16 KiB) Viewed 890 times
-
- colum and line chart question - before change.png (50.62 KiB) Viewed 890 times
- 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
You should use the "couleur" fields. One of them is for columns, one is for lines (my French is too bad)
Best regards, Alexander Dvoynev
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
-
- 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
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!
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
- 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
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
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.
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.