Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

I need help making a chart on microsoft Excel


  • Please log in to reply

#1
Bslforever

Bslforever

    Member

  • Member
  • PipPip
  • 21 posts
I want to make an IV curve (current on one axis, voltage on the other) and its just not working, no matter how i enter my data. Here is my data:

Current (mA) Potential Difference (V)
21.6 0.31
22.8 0.29
24.6 0.23
25.8 0.2
28.1 0.13
31.5 0.02

And it just wont work! I keep getting seperate series. Any help would be greatly appreciated.
  • 0

Advertisements


#2
Vino Rosso

Vino Rosso

    Visiting Staff

  • Visiting Consultant
  • 235 posts
Create the graph with the two sets of data on one axis then right-click on the data you want on the second axis and select Format Data Series > Axis Tab > click Secondary Axis
  • 0

#3
Jonesey

Jonesey

    Member

  • Member
  • PipPipPip
  • 335 posts

Create the graph with the two sets of data on one axis then right-click on the data you want on the second axis and select Format Data Series > Axis Tab > click Secondary Axis



That will work, but I created it simply by selecting all of the data [presumably arranged in a 2-column, 6-row range], then simply clicking the "Insert Chart" icon, choosing Line and away you go.

Milliamps on the X axis and Voltage on the Y axis.
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP