Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do I merge two graphs in excel?
I have created graphs in a worksheet on excel 2003 and I want to merge them
all onto one graph - there are 5 in total, each shows a range of job types on the X axis and the number of jobs on the Y axis. I feel as though I am missing something fundamental either in the way I have entered the data on the spreadsheet or missed something obvious on the help pages.Everything I have tried so far has either resulted in the data not transferring from one chart to the other or the line graph transferring but not the data labels. Any advice very much appreciated |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do I merge two graphs in excel?
I cannot help with merging existing charts. But you can have a single chart
with data from various regions of a worksheet. 1) In A1:A5 enter 1,2,3,4,5 and in B1:B5 enter 6,7,8,9,10 2) In D1:E1 enter some text (x and y will do) In D2:D4 enter 5.5, 6.5, 7.5 and in E2:E4 enter 12,13,14 3) Make an XY chart from A1:B5 4) Select D1:E4, and Copy 5) Click the chart and use Edit | Paste Special; specify New Series with x-values in left column and header at top; click OK Now the chart has two data series Any help? best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "lb82" wrote in message ... I have created graphs in a worksheet on excel 2003 and I want to merge them all onto one graph - there are 5 in total, each shows a range of job types on the X axis and the number of jobs on the Y axis. I feel as though I am missing something fundamental either in the way I have entered the data on the spreadsheet or missed something obvious on the help pages.Everything I have tried so far has either resulted in the data not transferring from one chart to the other or the line graph transferring but not the data labels. Any advice very much appreciated |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do I merge two graphs in excel?
Thanks Bernard,
That did help a little, am still having trouble with getting the chart to show the data along the x axis, e.g. categories a,b,c,d. The chart is plotting the info but it is only showing the categories for the first data series. Any ideas? lb "Bernard Liengme" wrote: I cannot help with merging existing charts. But you can have a single chart with data from various regions of a worksheet. 1) In A1:A5 enter 1,2,3,4,5 and in B1:B5 enter 6,7,8,9,10 2) In D1:E1 enter some text (x and y will do) In D2:D4 enter 5.5, 6.5, 7.5 and in E2:E4 enter 12,13,14 3) Make an XY chart from A1:B5 4) Select D1:E4, and Copy 5) Click the chart and use Edit | Paste Special; specify New Series with x-values in left column and header at top; click OK Now the chart has two data series Any help? best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "lb82" wrote in message ... I have created graphs in a worksheet on excel 2003 and I want to merge them all onto one graph - there are 5 in total, each shows a range of job types on the X axis and the number of jobs on the Y axis. I feel as though I am missing something fundamental either in the way I have entered the data on the spreadsheet or missed something obvious on the help pages.Everything I have tried so far has either resulted in the data not transferring from one chart to the other or the line graph transferring but not the data labels. Any advice very much appreciated |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do I merge two graphs in excel?
Yes, category charts (Line, column and bar) are a problem
My method works with XY charts only Have a look at the sites of the chart gurus http://peltiertech.com/index.html http://www.andypope.info/charts.htm best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "lb82" wrote in message ... Thanks Bernard, That did help a little, am still having trouble with getting the chart to show the data along the x axis, e.g. categories a,b,c,d. The chart is plotting the info but it is only showing the categories for the first data series. Any ideas? lb "Bernard Liengme" wrote: I cannot help with merging existing charts. But you can have a single chart with data from various regions of a worksheet. 1) In A1:A5 enter 1,2,3,4,5 and in B1:B5 enter 6,7,8,9,10 2) In D1:E1 enter some text (x and y will do) In D2:D4 enter 5.5, 6.5, 7.5 and in E2:E4 enter 12,13,14 3) Make an XY chart from A1:B5 4) Select D1:E4, and Copy 5) Click the chart and use Edit | Paste Special; specify New Series with x-values in left column and header at top; click OK Now the chart has two data series Any help? best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "lb82" wrote in message ... I have created graphs in a worksheet on excel 2003 and I want to merge them all onto one graph - there are 5 in total, each shows a range of job types on the X axis and the number of jobs on the Y axis. I feel as though I am missing something fundamental either in the way I have entered the data on the spreadsheet or missed something obvious on the help pages.Everything I have tried so far has either resulted in the data not transferring from one chart to the other or the line graph transferring but not the data labels. Any advice very much appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Are there better GRAPHS within EXCEL or Add-on graphs? | Charts and Charting in Excel | |||
Excel rounds up, then in mail merge uses nonrounded data | Excel Discussion (Misc queries) | |||
How do I Compare and Merge Workbooks in Excel? | Excel Discussion (Misc queries) | |||
Excel VBA Merge Workbook tables Central table | Excel Discussion (Misc queries) | |||
Automate Excel to powerpoint - Graphs along with Datasheet (not workbook) | Charts and Charting in Excel |