Excel charts (graphs) - diyAudio
Go Back   Home > Forums > General Interest > Everything Else

Everything Else Anything related to audio / video / electronics etc) BUT remember- we have many new forums where your thread may now fit! .... Parts, Equipment & Tools, Construction Tips, Software Tools......

Please consider donating to help us continue to serve you.

Ads on/off / Custom Title / More PMs / More album space / Advanced printing & mass image saving
Reply
 
Thread Tools Search this Thread
Old 27th March 2007, 10:21 PM   #1
diyAudio Member
 
Join Date: Mar 2004
Location: Texas
Default Excel charts (graphs)

I'm having a real problem trying to get Excel to draw a chart using the data in one column for the x axis and the data in another column for the y axis. I want the x axis to be logarithmic.

Anyone know how to accomplish this?
__________________
Any technology sufficiently advanced is indistinguishable from magic
  Reply With Quote
Old 27th March 2007, 10:52 PM   #2
Ron E is offline Ron E  United States
diyAudio Member
 
Ron E's Avatar
 
Join Date: Jun 2002
Location: USA, MN
From memory:

Select the data
make a "scatter" graph <---most important point
doubleclick on the graph
right click on the X axis
change the limits and select logarithmic
You are done.
__________________
Our species needs, and deserves, a citizenry with minds wide awake and a basic understanding of how the world works. --Carl Sagan
Armaments, universal debt, and planned obsolescence--those are the three pillars of Western prosperity. Aldous Huxley
  Reply With Quote
Old 28th March 2007, 02:15 AM   #3
diyAudio Member
 
Join Date: Mar 2004
Location: Texas
Thanks! That works great!

I just wish it worked with line charts.
__________________
Any technology sufficiently advanced is indistinguishable from magic
  Reply With Quote
Old 28th March 2007, 10:46 AM   #4
Ron E is offline Ron E  United States
diyAudio Member
 
Ron E's Avatar
 
Join Date: Jun 2002
Location: USA, MN
You can connect the dots with lines and even nix the data points if that's what you want.

activate the graph, select the data points (click on one and get them to highlight)
right click and select "format data" or something like that
change colors, data point types and lines, lineweights, etc...
__________________
Our species needs, and deserves, a citizenry with minds wide awake and a basic understanding of how the world works. --Carl Sagan
Armaments, universal debt, and planned obsolescence--those are the three pillars of Western prosperity. Aldous Huxley
  Reply With Quote

Reply


Hide this!Advertise here!
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How Spongebob hit the charts Netlist Pass Labs 3 5th February 2004 10:17 PM
equations for FR charts Dave Jones Multi-Way 4 24th December 2003 09:40 PM


New To Site? Need Help?

All times are GMT. The time now is 09:23 PM.


vBulletin Optimisation provided by vB Optimise (Pro) - vBulletin Mods & Addons Copyright © 2014 DragonByte Technologies Ltd.
Copyright 1999-2014 diyAudio

Content Relevant URLs by vBSEO 3.3.2