Jump to content

Welcome to Geeks to Go - Register now for FREE

Need help with your computer or device? Want to learn new tech skills? You're in the right place!
Geeks to Go is a friendly community of tech experts who can solve any problem you have. Just create a free account and post your question. Our volunteers will reply quickly and guide you through the steps. Don't let tech troubles stop you. Join Geeks to Go now and get the support you need!

How it Works Create Account
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