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 » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Is this chart possible?



 
 
Thread Tools Display Modes
  #1  
Old March 4th, 2009, 05:35 PM posted to microsoft.public.excel.newusers
Georges Heinesch[_2_]
external usenet poster
 
Posts: 5
Default Is this chart possible?

Hi.

I would like to visuablize the following data (simplified from real
data) in a chart. I fiddled around for +1 hours and didn't even get
something close to what I had in mind.

time value1 value2
13:15 10 0.25
13:17 110 0.95
13:26 140 0.99
13:45 150 1.14
13:47 150 1.00

This data represents measurement times of 2 values, which I would like
to show in a line graph.

The times are not equally distributed. They should be on the x-axis.

value1 and value2 should be on the y-axis. Both values should use their
own scale in order to maximize the y-axis.

It should somewhat like this:

150 / 1.12 # 1 1
# 1 2
# 1 2 2
# 2
#
#2
#
#1
#####################################
13:15 13:47

Is chart this possible?

Thanks.

--
Georges Heinesch
  #2  
Old March 4th, 2009, 06:02 PM posted to microsoft.public.excel.newusers
Bernard Liengme[_2_]
external usenet poster
 
Posts: 1,027
Default Is this chart possible?

Delete (at least for now) the word "time" to stop Excel treating that column
as a data series
Make an XY chart (NOT a Line chart)
Format one data series to have a secondary y-axis
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Georges Heinesch" wrote in message
...
Hi.

I would like to visuablize the following data (simplified from real
data) in a chart. I fiddled around for +1 hours and didn't even get
something close to what I had in mind.

time value1 value2
13:15 10 0.25
13:17 110 0.95
13:26 140 0.99
13:45 150 1.14
13:47 150 1.00

This data represents measurement times of 2 values, which I would like
to show in a line graph.

The times are not equally distributed. They should be on the x-axis.

value1 and value2 should be on the y-axis. Both values should use their
own scale in order to maximize the y-axis.

It should somewhat like this:

150 / 1.12 # 1 1
# 1 2
# 1 2 2
# 2
#
#2
#
#1
#####################################
13:15 13:47

Is chart this possible?

Thanks.

--
Georges Heinesch



 




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


All times are GMT +1. The time now is 07:06 PM.


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