Hi,
I use Cognos to do reporting. I export a chart from cognos to excel and it produces the attached chart. Is there any way to create a sequential line chart, broken up into series like the attached chart?
Any help with reproducing this chart using excel data would be appreciated.
Thanks in advance.
Johnnyg
You just need to lay your data out correctly.
Each series should have enough rows to cover the points on the x axis.
But only have values for those points that require plotting.
Thanks very much. Your response was perfect, once I worked out what you meant. It's easy when you know how !
For others, I have attached a screen shot of the layout solution.
Thanks again.
Johnnyg
![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks