A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Bar graph and line graph overlayed



 
 
Thread Tools Display Modes
  #1  
Old January 2nd, 2006, 09:43 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Bar graph and line graph overlayed

This relatews to my previous post about '2 seperate clusters of bars...' (not
sure how to give the direct link here).

What I am struggling to do with basic excel skills is to gab the data of
several stores and showing each store performance by month for 2004 and
comparing this with those same months for 2005. There are 12 stores and moths
from July to December. I wuld like to be able to see all on one graph but so
far it is not looking very clear. SO... I have then thought of looking at
each store in it's own graph and using the Bar graph for months of 2005 and
have a line graph over / on the same graph for that store of the 2004 data so
show the trend and change in performance.

Is that posiible and how?

Thanks
Mike
  #2  
Old January 3rd, 2006, 01:28 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Bar graph and line graph overlayed

Answering your specific question, create a column chart. Next, in the
chart, select the series you want as a line. Then, select Chart |
Chart Type... | and select the desired chart and sub-type.

To use a single chart for all the stores, adapt the ideas (particularly
example 6) in
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

Depending on how your data are organized, you may be able to create a
PivotTable and PivotChart. If so, you may find useful
PivotChart Drilldown
http://www.tushar-
mehta.com/excel/software/pivotchart_drilldown/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
This relatews to my previous post about '2 seperate clusters of bars...' (not
sure how to give the direct link here).

What I am struggling to do with basic excel skills is to gab the data of
several stores and showing each store performance by month for 2004 and
comparing this with those same months for 2005. There are 12 stores and moths
from July to December. I wuld like to be able to see all on one graph but so
far it is not looking very clear. SO... I have then thought of looking at
each store in it's own graph and using the Bar graph for months of 2005 and
have a line graph over / on the same graph for that store of the 2004 data so
show the trend and change in performance.

Is that posiible and how?

Thanks
Mike

  #3  
Old January 3rd, 2006, 10:39 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Bar graph and line graph overlayed

Thanks Tushar , But I do not know how to do what you have suggested. I have a
bar chart that has the store with the months listed as rows and the 2 columns
- 1 for 2004 and the other 2005. Now I can get a bar graph that has both the
months for 2004 and then on the same graph a block of months for 2005. I do
not know how though to follow your instructions "Next, in the
chart, select the series you want as a line. Then, select Chart |
Chart Type... | and select the desired chart and sub-type." If I R-Click on the bar graph and select data series and change this I can only get part of the data as a bar. What I need to do is get say the 2005 data as a Bar and then overlay the 2004 as a line. Can you provide more detailed instructions for me to follow?


I would then like to overlay this graph with a 3rd set od data or variable
such as number of customers.

Cherrs
Mike



"Tushar Mehta" wrote:

Answering your specific question, create a column chart. Next, in the
chart, select the series you want as a line. Then, select Chart |
Chart Type... | and select the desired chart and sub-type.

To use a single chart for all the stores, adapt the ideas (particularly
example 6) in
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

Depending on how your data are organized, you may be able to create a
PivotTable and PivotChart. If so, you may find useful
PivotChart Drilldown
http://www.tushar-
mehta.com/excel/software/pivotchart_drilldown/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
This relatews to my previous post about '2 seperate clusters of bars...' (not
sure how to give the direct link here).

What I am struggling to do with basic excel skills is to gab the data of
several stores and showing each store performance by month for 2004 and
comparing this with those same months for 2005. There are 12 stores and moths
from July to December. I wuld like to be able to see all on one graph but so
far it is not looking very clear. SO... I have then thought of looking at
each store in it's own graph and using the Bar graph for months of 2005 and
have a line graph over / on the same graph for that store of the 2004 data so
show the trend and change in performance.

Is that posiible and how?

Thanks
Mike


  #4  
Old January 3rd, 2006, 11:09 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Bar graph and line graph overlayed

Tushar- You have opened a whole new world for me in excel - my 'sum' commands
are about the extent of my excel expertise and having a read of your 'dynamic
charts' is really quite inspiring. Thaks. I now need to work out how to graph
various variables of data across the one graph such as sales , number of
customers, time in store. for each store over a period of time.
Cheers
Mike

"Tushar Mehta" wrote:

Answering your specific question, create a column chart. Next, in the
chart, select the series you want as a line. Then, select Chart |
Chart Type... | and select the desired chart and sub-type.

To use a single chart for all the stores, adapt the ideas (particularly
example 6) in
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

Depending on how your data are organized, you may be able to create a
PivotTable and PivotChart. If so, you may find useful
PivotChart Drilldown
http://www.tushar-
mehta.com/excel/software/pivotchart_drilldown/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
This relatews to my previous post about '2 seperate clusters of bars...' (not
sure how to give the direct link here).

What I am struggling to do with basic excel skills is to gab the data of
several stores and showing each store performance by month for 2004 and
comparing this with those same months for 2005. There are 12 stores and moths
from July to December. I wuld like to be able to see all on one graph but so
far it is not looking very clear. SO... I have then thought of looking at
each store in it's own graph and using the Bar graph for months of 2005 and
have a line graph over / on the same graph for that store of the 2004 data so
show the trend and change in performance.

Is that posiible and how?

Thanks
Mike


  #5  
Old February 6th, 2006, 08:01 AM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Bar graph and line graph overlayed

Dear Tushar- I find the Dynamic Graphs wonderful albeit I do not understand
how to do this yet with my minimal knowledge of excel. But is it possible to
have a series of stores, with 3 variables being recorded across months of the
year and have technique 6 to drop down the store name and the variable
requied? Would it be one drop down box/windows that lists:- Store A-
Variable A, Store A Variable B, Store A Variable C , then Store B etc etc
Thanks
Mike

"Tushar Mehta" wrote:

Answering your specific question, create a column chart. Next, in the
chart, select the series you want as a line. Then, select Chart |
Chart Type... | and select the desired chart and sub-type.

To use a single chart for all the stores, adapt the ideas (particularly
example 6) in
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

Depending on how your data are organized, you may be able to create a
PivotTable and PivotChart. If so, you may find useful
PivotChart Drilldown
http://www.tushar-
mehta.com/excel/software/pivotchart_drilldown/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
This relatews to my previous post about '2 seperate clusters of bars...' (not
sure how to give the direct link here).

What I am struggling to do with basic excel skills is to gab the data of
several stores and showing each store performance by month for 2004 and
comparing this with those same months for 2005. There are 12 stores and moths
from July to December. I wuld like to be able to see all on one graph but so
far it is not looking very clear. SO... I have then thought of looking at
each store in it's own graph and using the Bar graph for months of 2005 and
have a line graph over / on the same graph for that store of the 2004 data so
show the trend and change in performance.

Is that posiible and how?

Thanks
Mike


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to "not show" piece of line in graph Callan Charts and Charting 5 October 8th, 2005 03:42 AM
Line Graph Data Recognition Nat Charts and Charting 2 April 30th, 2005 02:07 PM
vertical line in graph Jack Sons General Discussion 1 August 15th, 2004 06:39 PM
[URGENT] Line Graph jamesjustinaaron General Discussion 1 July 28th, 2004 07:24 PM
The line in a line graph Andy Pope Charts and Charting 1 June 8th, 2004 10:32 PM


All times are GMT +1. The time now is 04:08 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.