Bar and stacked bar graph in single graph

[Solved/Closed]
Report
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
-
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
-
Hello,

hi i have to make chart using three field month wise. and i want to make bar for first field and stacked bar for next two within same graph. can it possible. my data looks like.

Month Sales Point Redeem
Jan 1000 600 500
Feb 500 300 300
Mar 800 700 650
Apr 600 700 400
May 900 400 300

Thanks!
Rahul

4 replies

Posts
2807
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 21, 2021
482
Hi Rahul,

Don't think that is possible.

In your case I would use a stacked column in combination with a line to create a graph looking close to what you have in mind.

Is that something you can work with and if so do you know how to create one?

Best regards,
Trowa
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
119
Thanks Trowa,

Can you explain the process how to create this.
Posts
2807
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 21, 2021
482
Hi Rahul,

Sure thing.
It's probably easier then you think.

Select your data including header.
Create graph, choosing stacked column as graph type.
Right-click on the sales part of the stacked column.
Choose graph type and choose line.
After that I would advise you to thicken the line for a better looking result by right-clicking the line and choosing the top option.

Best regards,
Trowa
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
119
not upto the expectation level,

anyway thanks Trowa