#### Plotting multiple Y column data versus single X column in Excel 20

I have data arranged as Time of day in column B and multiple Y values as
columns D, F, and G
How do I get a multiple line chart with the multiple Y values plotted versus
the single column of time values in Column B?

Thanks

RossM

 0
RossM (3)
6/26/2009 8:21:01 PM
excel.charting 18370 articles. 0 followers.

3 Replies
651 Views

Similar Articles

[PageSpeed] 15

Select the column of times, then hold ctrl while selecting the data in
column D, and while selecting the data in F and G. Create an XY chart, using
the option with markers and lines.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______

"RossM" <RossM@discussions.microsoft.com> wrote in message
news:869486D9-8280-4144-ACDF-6018E584AF6B@microsoft.com...
>I have data arranged as Time of day in column B and multiple Y values as
> columns D, F, and G
> How do I get a multiple line chart with the multiple Y values plotted
> versus
> the single column of time values in Column B?
>
> Thanks
>
> RossM


 0
jonxlmvpNO (4558)
6/27/2009 6:12:44 PM

Many thanks. It worked, of course.
Now, the data is plotted from Midnight through until just after the data
stops.
The values are zero until about 5:30 AM. How do I change the horizontal
scale to plot only the nonzero data?

I clicked on Axes on the Layout tab. Then I clicked on Primary Horizontal
Axis and More Primary Horizontal Axis Options so I could enter minimum and
maximum values with "Fixed" checked. Unfortunately, I did not know how to
enter 5:45 AM and 9:00 PM in a way that the program would recognize it. It
didn't accept 5:45:00 and 11:00:00 as start and end hours and the plots
disappeared.

I then tried clicking on "Number" in the list on the left and selected a
time format, like 13:30 and then clicked back on Axis Options to return to
that menu, so I could enter the Minimum and Maximum times as 5:45 and 11:00
but it would not accept this format and defaulted back to 0.0 and 0.45 for
Max and Min. I also tried using the format shown on the menu: h:mm:ss;@ but
that didn't work either. Your additional help will be appreciated.

Oh, also, when I recieved the e-mail notice of your posting and clicked on
the link, it went to Mozilla Firefox and put the link in the proper window
but immediately said lower left "Done" with a blank window, so I had to
search on the above subject in the Discussion group. When I last did Update,
it put in a new version of Internet Explorer and after that I couldn't get IE
to work and it did bad things so I uninstalled it, so don't have that option
available.

Thanks
RossM

"Jon Peltier" wrote:

> Select the column of times, then hold ctrl while selecting the data in
> column D, and while selecting the data in F and G. Create an XY chart, using
> the option with markers and lines.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services, Inc.
> http://PeltierTech.com/WordPress/
> _______
>
>
> "RossM" <RossM@discussions.microsoft.com> wrote in message
> news:869486D9-8280-4144-ACDF-6018E584AF6B@microsoft.com...
> >I have data arranged as Time of day in column B and multiple Y values as
> > columns D, F, and G
> > How do I get a multiple line chart with the multiple Y values plotted
> > versus
> > the single column of time values in Column B?
> >
> > Thanks
> >
> > RossM
>
>
>

 0
RossM (3)
6/27/2009 10:36:01 PM
In Excel 2003 and earlier, you can enter times in h:m:s format, so 5:45 and
21:00 should work.

In Excel 2007, this ability to enter times was forgotten until SP2. If you
have 2007, go to Office Update and apply this service pack.

And I have no idea how any of the web interfaces work for this forum, but I
do know the MS one is among the most awkward. If you look under "Microsoft
Newsgroups" on my blog entry
http://peltiertech.com/WordPress/finding-help-for-microsoft-excel/, you will
see an alternative and more effective way to read these forums.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______

"RossM" <RossM@discussions.microsoft.com> wrote in message
news:F591090C-A1CC-4F91-968B-03CEC9FD4303@microsoft.com...
>
> Many thanks. It worked, of course.
> Now, the data is plotted from Midnight through until just after the data
> stops.
> The values are zero until about 5:30 AM. How do I change the horizontal
> scale to plot only the nonzero data?
>
> I clicked on Axes on the Layout tab. Then I clicked on Primary Horizontal
> Axis and More Primary Horizontal Axis Options so I could enter minimum and
> maximum values with "Fixed" checked. Unfortunately, I did not know how to
> enter 5:45 AM and 9:00 PM in a way that the program would recognize it. It
> didn't accept 5:45:00 and 11:00:00 as start and end hours and the plots
> disappeared.
>
> I then tried clicking on "Number" in the list on the left and selected a
> time format, like 13:30 and then clicked back on Axis Options to return to
> that menu, so I could enter the Minimum and Maximum times as 5:45 and
> 11:00
> but it would not accept this format and defaulted back to 0.0 and 0.45 for
> Max and Min. I also tried using the format shown on the menu: h:mm:ss;@
> but
> that didn't work either. Your additional help will be appreciated.
>
> Oh, also, when I recieved the e-mail notice of your posting and clicked on
> the link, it went to Mozilla Firefox and put the link in the proper window
> but immediately said lower left "Done" with a blank window, so I had to
> search on the above subject in the Discussion group. When I last did
> Update,
> it put in a new version of Internet Explorer and after that I couldn't get
> IE
> to work and it did bad things so I uninstalled it, so don't have that
> option
> available.
>
> Thanks
> RossM
>
>
> "Jon Peltier" wrote:
>
>> Select the column of times, then hold ctrl while selecting the data in
>> column D, and while selecting the data in F and G. Create an XY chart,
>> using
>> the option with markers and lines.
>>
>> - Jon
>> -------
>> Jon Peltier, Microsoft Excel MVP
>> Peltier Technical Services, Inc.
>> http://PeltierTech.com/WordPress/
>> _______
>>
>>
>> "RossM" <RossM@discussions.microsoft.com> wrote in message
>> news:869486D9-8280-4144-ACDF-6018E584AF6B@microsoft.com...
>> >I have data arranged as Time of day in column B and multiple Y values as
>> > columns D, F, and G
>> > How do I get a multiple line chart with the multiple Y values plotted
>> > versus
>> > the single column of time values in Column B?
>> >
>> > Thanks
>> >
>> > RossM
>>
>>
>>


 0
jonxlmvpNO (4558)
6/28/2009 12:39:11 AM

Similar Artilces:

UI Data Validation using XML Schema
Has anybody done UI data validation usinf XML Schemas. Any pointers will help. Thanks! ...

edit Punlisher version in multiple documents
I have a publisher folder that contains several other folders. In these "sub folders" are publisher documents for departments to revise for a City-wide publication. My problem: documents are saved in Publisher 2003 and not all departments have the latest version. I want to convert all of the documents into Publisher 2000 so they can be opened and modified by departments. How do I "save as" Publisher 2000 without opening each foler and then each document. Do advanced attributes work? How? Many thanks for any help. You don't want to hear the answer. You alrea...

Excel 07 selects 3 cells when I click on 1
Hi I just got 2007 (I want 2000 back) and a lot of the time when click on an empty cell 2 or more below it are selected and the typing goes on the bottom row. I just want to select the cell I click on. Thanks Are the cells merged?? I don't like the 2007 either! If i could i would have the look and feel of 2003 on the engine of 2007... :-( On Thu, 1 Nov 2007 20:21:01 -0700, Brian <Brian@discussions.microsoft.com> wrote: >Hi I just got 2007 (I want 2000 back) and a lot of the time when click on an >empty cell 2 or more below it are selected and the typing goes on the botto...

Excel 2003/edit/replace. Under Options/Look In, values is AWOL bu.
Under Look In options Find allows for search by formulae OR values OR comments Replace is restricted to formulaes ONLY WHY? cp Have a look at this google search result. This topic came up a couple days ago and was addressed by Dave and Myrna. http://snipurl.com/cd9j Gord Dibben Excel MVP On Fri, 28 Jan 2005 03:49:02 -0800, "cp" <cp@discussions.microsoft.com> wrote: >Under Look In options >Find allows for search by formulae OR values OR comments >Replace is restricted to formulaes ONLY >WHY? ...

Change paths to linked external data
Hello. I have a database that has 3 external links in it: 1 is to a table in another Access Database. One is to an excel spread sheet. And, the third is to a .csv file. Is there a way in VBA to change the paths to these? Basically, i want to set up a form where the user can specify the new paths in text boxes if any of these files are moved. Anybody help me out? (Access 2007) cyb3rwolf wrote: >Hello. I have a database that has 3 external links in it: 1 is to a table >in another Access Database. One is to an excel spread sheet. And, the third >is to a .csv...

how do i enable dde in excel?
i am posting a DDE link into an excel cell from an external program and getting the message ' DDE Not enabled' in the cell once the link is pasted in. how do i enable DDE? ...

Something destroying Money data
My MS Money 2007 software was working fine, and then a few months ago, there were transactions missing. I went for backups, and it seemed every time I opened a MOney file there were fewer transactions--it was truly weird. Thinking a file had been accidentally deleted, I used a file recovery program and retrieved file and backup - also no data. So I just put the whole thing aside and out of mind, but tried again today and searched all partitions for mny and mbf files.. Same result, if anything fewer transactions. Is there some virus or other malware that eats Money files? I guess I can d...

XML into DataSet
Hi. I need some help. I have an xml file what will contain hundreds of groups and will have an associated xsd. My overall goal is to have a web application that allows a user to input a groupID from a webform, the application will than find that groupID in the xml file and display all the related information for that group only. I have read my xml into a DataSet and have been able to successful find groupID and display some of the information for that particular group. But I have been unable to navigate to the groupsItems node and subsequently the details of each groupItem found in gro...

How to transpose in excel file
Hi I would like to make a transpose like this? From House Defect How much #1 Broken Sinks 1000 #1 Bad Paint 2000 #1 Bad Lighting 1000 #2 Broken Sinks 0 #2 Bad Paint 2000 #2 Bad Lighting 100 and Transpose into House Broken Sinks Bad Paint Bad Lighting #1 1000 2000 1000 #2 0 2000 100 A Pivot Table will do that and more. Set House as row field, Defect as column field and How much as data. HTH. Best wishes Harald "vilfood" <vilfood@d...

excel file can't be opened #2
hi,I'm cho I have a recent excel file (about 1 month),but since two days ago,the file can't be opened completely or always not responding. What should I do so that I can use this important file. Any help would be appreciated regards, cho ...

Need specific tick marks on Y axis
I am sure this is probably something really easy, but for the life of me I can't seem to figure it out. I tick marks on the y axis from 0 to mark 260 and 420. The biggest that I would need is 600, but I must have the 260 and 420 marked. How do I do that? I tried to change the minor/major things, but that didn't work out. I am trying to chart my peak flow readings for my asthma, and the 420 and 260 designate the zone lines of how bad my asthma is. Thanks in advance! ") You can put "ticks" wherever you want following this procedure: http://peltiertech.com...

Autofill from column to row
I have a worksheet with data in a column and want the data on another sheet in a row, sorted in another way. I tried to use autofill to get data from every 25th cell in the column to the row on the other sheet, ['sheet 1'!F2"] in cell B2, ['sheet 1'!F27] in cell C2, ['sheet 1'!F52] in cell D2 and so on. Excel autofill wont understand what I want, is there any other way of solving this? One way In the destination sheet: Put in B2: =OFFSET('Sheet 1'!$F$2,COLUMNS($A$1:A1)*25-25,) Copy B2 across to D2 B2:D2 will return the desired contents, viz.: in...

Headers in Excel #3
Can you tell me if it's possible and if so, how I can change the header cells, i.e. A B C D E ... etc? Thanks. Andrea (508) 842-3880 Hi Andrea no this is not possible. The best workaround you can achieve is: - use row 1 as header - goto cell A2 and to the menu 'Windows - Freeze Panes' to always show row 1 - in 'Tools - Options - view' you can hide the row and column headers -- Regards Frank Kabel Frankfurt, Germany "Andrea" <shrews.receptionist@nitco-lift.com> schrieb im Newsbeitrag news:12ff301c44354$b88982b0$a501280a@phx.gbl... > Can you tell ...

Hi all, any ideas on this.... We have created a number of Quotation Reports that work fine for all users except one ! When she runs the report she gets an error saying the sub report can be found. I have checked that she is in the same CRM groups as other users and checked that she is in the Reporting group in Windows/SQL - all looks fine. Any help would be appreciated Thanks Ian Hi Ian, Does she have problem with this report only or this happens to her other reports as well? Darren Liu, Microsoft CRM MVP http://www.crowecrm.com On Nov 7, 5:29 am, "Ian Kelsall" <...

Select Multiple Folders
I have an Excel application, where the user can browse to a folder and process all the documents in that folder. I use the Office 10 FileDialog object (FolderPicker) to allow the user to do this with an easily recognizable dialog box. The problem is, the users would like to select multiple folders at a time (which FolderPicker does not allow). I could allow them Browse and select a folder, add it to a list, then Browse again and add to the list, then Browse again, but that would be a long tedious process. Is there anything that would allow me to select multiple folders at a time, similar to...

Excel -> Access Import Bizarreness
A guy gave me an Excel file that he needs me to covert to XML. No problem. Slurp it into a database and use a DataSet.WriteXML() call to turn it into an XML file. But I can't import it into Access because it has "Merged Cells". For example, data that should look like this: ColA ColB ----- ----- Rec1 this Rec2 this Rec3 this Rec4 that Rec5 Other The three "this" cells have been merged into one tall cell: ColA ColB ----- ----- Rec1 this Rec2 Rec3 Rec4 that Rec5 Other I need to "unmerge" these, but I know almost nothi...

Is this possible within Excel 2000?
Hi, I've used Excel on a get by basis for many years at work, and I'm just beginning to realise its vast capabilities, having viewed several groups which I didn't know existed previously. I subsequently would like to ask if it is possible for Excel to look at the numerical or text content of a cell on one worksheet and then look at a predefined range on another worksheet and find the equivalent cell content and then move the cursor to that cell? This has me stumped presently. Thanks in advance for any assistance. J.J. To actually move the selection, you'd need to use a litt...

HowTo add row to series data
1) insert row with ShiftDown 2) apply new data to the newly emptied cells 3) preserve original chart series range 1) after this code row 2 is empty cells Excel.Worksheet chart = (Excel.Worksheet)book.Worksheets["Chart Data"]; Excel.Range rngToday = chart.get_Range("A2", "D2"); rngToday.Insert(Excel.XlInsertShiftDirection.xlShiftDown); 2) this puts todays date into A2 rngToday.NumberFormat = "MM/dd"; rngToday.Value = DateTime.Today; 3) OOPS - the chart data is now A3..A7 because of the insert above How do I reset the souce data to A...

Excel 2000 fail to open workbook
Hi, I have one Excel template. If we open it on Excel 2000, the Excel will hang, and the process occupy cpu 95% ~98%. But we can open this tempalte in Excel 2003 normally, and if we save this tempalte in Excel 2003, and then open it in Excel 2000, it work normally too. Excel 2000 (9.0.3821 SR-1) Excel 2003 (11.8231.8221) sp3 Would you help us to find the reason for this issue? Thanks, Nancy Hi Nancy, Perhaps there was some (probably minor) corruption/inconsistency in the workbook that Excel 2003 could fix but Excel 2000 couldn't. -- Cheers macropod [Microsoft MVP - Word] ...

How can I create an invoicing database in Excel?
I would like to know how to create an invoicing database, or register in Excel. (Invoice + tax = total) Are there any templates free online? thanks How about a web search? http://office.microsoft.com/en-us/templates/default.aspx search for invoice -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "Vcollins" <Vcollins@discussions.microsoft.com> wrote in message news:C46E9FE2-0B38-4468-9B00-126B7EE5C9A2@microsoft.com... >I would like to know how to create an invoicing database, or register in &...

Deleting Multiple Public Folders
Hi Folks; I have Exchange 2000 installed and I had configured a newsfeed. That made about 65,000 public folders and I later decided to remove the newsfeed. I can delete the folders one by one but I can't seem to delete them all en masse. Does anyone know how to efficiently delete these public folders? Unsubscribing from the newsfeed first, of course. Can you delete multiples using Outlook? "Marvin Miller" <sales@real.com> wrote in message news:e49WxLcYGHA.4884@TK2MSFTNGP02.phx.gbl... > Hi Folks; > > I have Exchange 2000 installed and I had configured a news...

Excel prints some sheets very small
When I try to print multiple sheets of the same workbook at the same time, one of them (a different one each time) prints very small (about an inch tall) in the upper left hand corner. I am printing from a network file but I don't know if this has anything to do with it or not. Please HELP!!! ...

EXCEL 2007 acting up
j$= "THIS MACRO WILL ERASE THE SECOND & THIRD SET OF DATA" + Chr$(13) + Chr$(13) Using EXCEL 2007, I get an error with the line above as a macro. It does not recognize CHR$. What am I doing wrong? Thanks Not for me it didn't. Check for MISSING references in Tools>References, uncheck them if there are any. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "pcor" <pcor@discussions.microsoft.com> wrote in message news:F63F6E95-AF0A-4927-B337-99B5C48B92B1@microsoft.com... > j\$ = "THIS MACRO WILL...