How do I plot both line and column data on same graph?

I have 5 series of data that need to be plotted.   The x-axis is the same for 
all, however I need the first series in column form and the remaining 4 in 
line form.  Can anyone tell me how to do this?  Thanks!!
0
jackie (70)
5/3/2005 3:15:01 PM
excel.charting 18370 articles. 0 followers. Follow

1 Replies
576 Views

Similar Articles

[PageSpeed] 54

Jackie,

Click once on the column that you want to be a line
Right-click on your mouse
Select Chart-type from the menu
In the Chart-type dialog box -> Standard Types tab - select line
Hit the OK button

-- 
Regards,
John Mansfield
http://www.pdbook.com


"Jackie" wrote:

> I have 5 series of data that need to be plotted.   The x-axis is the same for 
> all, however I need the first series in column form and the remaining 4 in 
> line form.  Can anyone tell me how to do this?  Thanks!!
0
5/3/2005 4:10:18 PM
Reply:

Similar Artilces:

Moving CRM but not the data
We have a CRM 3.0 deployment where CRM is on one server, and the SQL database is on another. Is it fairly simple to reinstall CRM on a NEW server, and just point to the current SQL database if we want to turn off the current CRM server? -- Gavin -- Small Business Server Specialist Microsoft CRM Specialist Microsoft Certified Partner www.interprom.com Yes. Just do the install on the new machine and point to the existing DB's during the setup. After it's working, you can uninstall from the old machine. -- Matt Parks MVP - Microsoft CRM "Gavin Steiner" <gavin@...

Display total of stacked column?
Running Excel 2000 on Windows 2000 Professional Is there any way to display the total of the elements of a stacked column at the top of the column? I have a stacked column chart that shows four elements in each bar. I chose "show values" on the "Data Label" tab in chart options. This shows the values of each element in the bar. In addition to these numbers, I need the total of the four elements displayed at the top of each column. Haw can I do this? Suggestions? Found KB article that works. Just had to create a new series with the totals and change the format s...

multi line edit control
This is a silly question, but the answer has escaped me. I'm building a CString in code and want to load it in a multi line edit control. Normally I would use '\n' for a new line but the edit control doesn't process this. What character should I insert in the CString to start a new line? The edit control is set to multi line and accept return. Thanks, Paul Use \r\n (CR NL) Tom "NewbProgrammer" <paul_kiefer@hotmail.com> wrote in message news:1112052481.005772.320490@g14g2000cwa.googlegroups.com... > This is a silly question, but the answer has escaped ...

40 Column Receipt WITOUT item comments
OK - I admit I am totally confused. I was thinking that item comments (CTRL F10 at POS) were not printing out on the 40 col OPOS receipt register. However, they are printing and the ~ is in the alignment. ???? The customer does NOT want them to print. I was thinking that without the ~ (on a windows printer only) the description would the line wrap and show the comments. Again, they want the description to print and not wrap to show the comments. - <TABLE> <FONT>"Small"</FONT> <BORDER>tbNone</BORDER> - <COLUMNHEADER> <ALIGNMENT&...

Data not showing in combo box
I have a database which uses a combo box with 2 columns, in Access 2007 I can see the information from both, in Access 2003 I can only see the data from column 2, if I go to the SQL query and run that I can see both so I know the data is there. Strangely if I try in Access 2000 I can see the data no problem, This database was designed originally in 2000 and has been running fine on all versions untill now so I am baffled - any suggestions so my colleague can use in 2003 would be much appreciated. I have tried on a 2nd machine with 2003 and still does not work. Sheila There was a bug...

Can the MSDN version of CRM 1.2 be converted to a production system without losing any data?
I have the MSDN version of CRM. If I install it and configure a pilot system, can I later convert it to a full licensed system without losing any data? Does it require a new installation or just change the Company Name and License Key? Bill Walter Bill, You would need to migrate the data to the new install. The AD objects & DB Names are tied to the Org Name so you can't change them once they're installed. You're best bet would probably be to use the DMF to load the data to the new install. BTW, I believe, technically, that using the MSDN license for a Pilot is not allow...

Hide columns
I am trying to hide two consecutive columns but get an error message saying "Cannot shift objects off sheet". What does this mean/what is causing this? The data in these two columns is no different than the data in the 20+ columns I have been able to successfully hide previously (in this same file). I've seen this message when there are no free columns in the worksheet. Check for rogue entries in column IV. HTH "alm09" wrote: > I am trying to hide two consecutive columns but get an error message saying > "Cannot shift objects off sheet". What d...

Tested hardware VSS provider table for Data Protection Manager
The table at the link below contains the list of VSS hardware provider tested to be compatible with DPM for protecting virtual machines deployed on clustered shared volumes (CSV). The fact that a VSS hardware provider for a certain SAN is not listed below does not mean that it is not compatible, but that it has not been tested. http://blogs.technet.com/dpm/archive/2010/02/05/tested-hardware-vss-provider-table.aspx J.C. Hornbeck | Microsoft ...

Line Column Graphs
I am trying to create a graph from 4 sets of data. I am looking at departmental success and as such have the success percentage for 3 individual departmenst in columns O,P&Q, and a global success rate in R. I want to create a graph with teh departmental success for each day shown in columns, and global success shown as a line. However, when I chose the Line Column Graph from the list, it only allows me to have 2 columns as opposed to the 3 I require. Can anyone help? Cheers Andy Hi, It will be easier if you create a standard column chart based on the 4 sets of data. Then s...

Plots
This is a multi-part message in MIME format. ------=_NextPart_000_0015_01C50860.E8475A00 Content-Type: text/plain; charset="koi8-r" Content-Transfer-Encoding: quoted-printable Are there in Visual C++ plots drawing library like BCB TeeChart? Thanks in advance. ------=_NextPart_000_0015_01C50860.E8475A00 Content-Type: text/html; charset="koi8-r" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; charset=3Dkoi8-r&q...

External data retrieve timescale
Is there any way to lower the Refresh External Data time to below 1minute? Thank you. Richard Hi Richard, using application.ontime you can schedule a procedure that will refresh your data more often than once per minute. Regards, Ivan ...

Invisible Data
Hi, After data is placed in form, it doesn't show up after the form is opened again. If i change the properties to NO data entry, the data will pop up again, but after closing and opening the form again, it disappears again. The data is in the tables/reports but won't stick in the form. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200801/1 Are you saying that your form has the DataEntry property set to True? The sole purpose of that property is to determine whether existing records are displayed. If it's True, the form show...

Outlook Format and line spacing.
I write a message/letter on HTML format single line spacing, and when the Reply comes back to my Inbox my original message is in double line spacing. Even when I write a "test" letter to myself, again in HTML single line space, the letter appears in my "In box" in double line spacing. How can we cure this? ...

print Grid Lines
when i try to print grid lines they dont print, i have tried to look at "format cell" then boarders and selected inside with a solid black line. i have also checked the "page setup" and the "sheet tab" and chedked "grid lines" but i still cannot print grid lines. will some one please help me. >-----Original Message----- >when i try to print grid lines they dont print, i have >tried to look at "format cell" then boarders and selected >inside with a solid black line. i have also checked >the "page setup" and th...

Macro to change position of chart labels on line chart
Hello all, I have quite a trickly problem to solve and I would appreciate any suggestions. I have a dashboard page in a worksheet which shows financial KPIs (i.e. sales) as forecast this year versus last year. There are a number of line charts on the dashboard showing the differing forecasts; the user of the dashboard can choose a business unit to view. What I would like to be able to do is to have the chart labels for these charts automatically change their aligmnent so that they display properly. I have set the chart labels to display "Above" for the new forecast and "Bel...

plotting long plots
I have a HP designjet 110 nr plotter. I've created a plot that we nee to show drilling activity. My first plot was 24"x36". Plot works grea and to scale. My next plot was to be 24"x72". Now the charts will no even display in Print Preview. I can scale back the plot where it i about 48" and it will preview and plot, but I need it to go out eve futher than 72 inches. I may go out as far as 30 feet. I have images on the plot area and it will print it just fine at th farther distances -- TexasDa -----------------------------------------------------------------------...

Importing Data #2
I am new to Money having previously been doing my own accounts in Excel. I have data that could be used in money - payee, category, date, account, amount etc. Is there any way of importing this data into Momey? Thanks Max In microsoft.public.money, Max Scott wrote: >I am new to Money having previously been doing my own accounts in Excel. I >have data that could be used in money - payee, category, date, account, >amount etc. Is there any way of importing this data into Momey? Money can File->Import QIF and OFX files. QIF is simpler. QIF does include payee, category, date, and...

Creating relationship to Contract Lines
I have created a custom entity for subcontractors and I want to add a relationship from the Contract Lines entity to subcontractors. i.e. in service to allow the lookup of the subcontractor from a contract line. I can add a relationship to the Contract entity but not to Contract Lines. Any ideas why or how I can do this? -- JGC The reason you can't do this is that ContractLine is not a user owned entity. Contract line is kind of unique. Most entities are 'user-owned', 'organization-owned', and a few are 'business unit-owned'. The ownership is important becau...

External Data Source and Adjacent Column / Data
I have a worksheet that gets it's data from an external data source. On that same worksheet, the 2 columns immediately to the right of that dataset are for "Notes" and a date. My goal is that someone can put notes in that column and it "binds" itself to that line of data, such that if the data moves to a different row in the excel worksheet (because of other data changes or whatever), that note stays with it. And if that line of data is removed from the dataset, a refresh would also remove the note. Instead, data in "Note" is binding to the row number...

Plotting Data
Hi, how can I plot the analysis data in the document class, in its related view class. Is it possible to make plots like in MATLAB (surface plots,mesh plots of a matrix)??? ...

Getting charts to automatically pick data from a series
Can I get a chart to always use say the last 9 values of a series? Does excel also do interactive charts? Salmonh: Yes you can have Excel chart the last 9, 30 or whatever number of values that you would like. You'll need to use dynamic range names to do this. Here are several links that will get you started. http://www.stfx.ca/people/bliengme/ExcelTips/Dynamic.htm http://processtrends.com/pg_chart_tips.htm#Dynamic_Chart_Range_Names http://peltiertech.com/Excel/Charts/Dynamics.html The idea is to create dynamic ranges that will update as you add data and ...

import or query another db to get weekly data for a report
I realize I might not need an import because I don't want to write over the imported data each week. Do I use a SQL update or append query to get data from an Access db on our network? I don't see the tables in my query design tool so I'm wondering how I do the query if I can't see the tables for the other database. thanks, ...

No signature lines in replies
Hello, I have an ongoing problem: If I create new mail my signature line is embedded all right. But on the other hand, if I reply a message, the same signature line is not embedded to the mail! I have to do it manually. I set a signature text up in Tools>Options>Mail Format>Signatures for new messages as well as Signatures for replies and forwards i.e. both cases have a signature text. Any help will be appreciated. Thank you. Cem what version of outlook and are you using word or the outlook editor? -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in...

Read data from cells in different worksheets
Hi! I have a problem with my VBA code when I try to read values from cells in two different worksheets. When I run the macro the program tells me that I=B4m out of bound. But everything works when I save the data in the same worksheet. How shold I write the code so that this simple thing could work? The data should be read when the user makes a buttonlick and then it will be used later on. The code is simple like this: Public Sub Button1_Click() A =3D Worksheets("Page1").Range("N8").Value B =3D Worksheets("Page2").Range("I8").Value I want to save the ...

Filling Out Cells Based on Data Validation
I have created a drop down list using data validation. What I need to do now is have cells filled out based on the value selected. In this case, the list has three values (Cell A1), and I need to have a range of cells (C7 to C54) populate data based on the specific value in A1. The other data is on a sheet named "Data Entry." Is this enough information or would I need to provide more? VLOOKUP or INDEX and MATCH Where are the data to pull over located on Data Entry sheet? Gord Dibben MS Excel MVP On Tue, 1 Jun 2010 14:33:01 -0700, Ericc = <Ericc@discussi...