Author Topic: how to create line graph combine with bar graph  (Read 257 times)

Offline niza

  • Associate
  • **
  • Join Date: Apr 2018
  • Posts: 2
  • Forum Citizenship: +0/-0
how to create line graph combine with bar graph
« on: 16 Apr 2018 10:04:09 pm »
hi
i need help. is there any idea on how to combine line graph and bar chart where the bar chat is inverted from the top and the line graph is at the bottom.
« Last Edit: 24 Apr 2018 03:08:30 am by MFGF »

Offline niza

  • Associate
  • **
  • Join Date: Apr 2018
  • Posts: 2
  • Forum Citizenship: +0/-0
Re: how to create line graph combine with bar graph
« Reply #1 on: 17 Apr 2018 11:24:37 pm »
hi anybody can help

Offline Invisi

  • Community Leader
  • *****
  • Join Date: Sep 2016
  • Posts: 236
  • Forum Citizenship: +6/-3
    • Invisi - Vision on Information
Re: how to create line graph combine with bar graph
« Reply #2 on: 25 Apr 2018 03:30:56 am »
My tip is: don't do it. Why do you want to do such a chart?
Few can be done on Cognos | RTFM for those who ask basic questions...

Offline Reinhard

  • Community Leader
  • *****
  • Join Date: Nov 2017
  • Posts: 135
  • Forum Citizenship: +1/-0
Re: how to create line graph combine with bar graph
« Reply #3 on: 25 Apr 2018 03:40:36 am »
Hi,

you could build your own visualization with RAVE using json and then import it into your Cognos library. Otherwise I doubt that you can do this in C10 with charts with onboard functionality and with C11 charts were mostly replaced by visualizations.

Offline Lynn

  • Statesman
  • ******
  • Join Date: Apr 2008
  • Posts: 2,650
  • Forum Citizenship: +338/-1
Re: how to create line graph combine with bar graph
« Reply #4 on: 25 Apr 2018 10:13:00 am »
I agree with Reinhard that a custom visualization is likely the only option.

Here is a link to the visualization forum on developer works where you can search to see if anyone has done something similar.

https://www.ibm.com/developerworks/community/forums/html/forum?id=eb8a1fa2-f0a0-4672-9dae-a97f04dde74f

Offline hespora

  • Statesman
  • ******
  • Join Date: Nov 2015
  • Posts: 384
  • Forum Citizenship: +26/-0
Re: how to create line graph combine with bar graph
« Reply #5 on: 03 May 2018 02:24:13 am »
Guys....

legacy column chart, insert a calculated measure of ([your measure] * -1), format the y-axis (using pattern "#;#" or something like that) to ditch the negative sign, done.

 


       
Twittear