i have a one set of data showing a trend from 2005 to 2013 and below that showing a trend from Jan 14 till Jun 14. I need the first part of the data as Bar Graph and besides that i need the other half of monthwise data as line graph with both side axis. I am unable to get the same.
Attaching the pic of the graph how i need it. can anyone please help me in understanding how it can be done.......
Right click on any series and select "Change Chart Type".... It will change the type for the selected series only
Elegant Simplicity............. Not Always
Re: two type of graph in one chart
Still unable to get it.......
pasting the data down
2007-48.6
2008-46.4
2009-44.6
2010-53.1
2011-54.9
2012-59.6
Jan-14-62
Feb-14-60.8
Mar-14-59.9
Apr-14-59.2
May-14-58.3
Jun-14-59.6
ChartEx.xlsm
The example combines a bar graph and line graph.
As suggested create column chart using both sets of data.
Change chart type
Move to secondary axis.
Set both scales to start at zero.
Re: two type of graph in one chart
Hey Thankz Andy...... this was so easy.
Guess should have used a bit more brain.....
YW Blossom - anytime
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks