Bar and stacked bar graph in single graph

Solved/Closed
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
- Mar 7, 2011 at 11:54 PM
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
- Mar 15, 2011 at 12:31 AM
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

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
514
Mar 11, 2011 at 09:40 AM
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
0
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Mar 13, 2011 at 11:38 PM
Thanks Trowa,

Can you explain the process how to create this.
0
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
514
Mar 14, 2011 at 09:37 AM
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
0
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Mar 15, 2011 at 12:31 AM
not upto the expectation level,

anyway thanks Trowa
0