Excel charts (graphs)

johngalt47 · 27th March 2007, 10:21 PM

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?

Ron E · 27th March 2007, 10:52 PM

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.

johngalt47 · 28th March 2007, 02:15 AM

Thanks! That works great!

I just wish it worked with line charts.

Ron E · 28th March 2007, 10:46 AM

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...

27th March 2007, 10:21 PM	#1
johngalt47 diyAudio Member Join Date: Mar 2004 Location: Texas	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

27th March 2007, 10:52 PM	#2
Ron E diyAudio Member 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

28th March 2007, 02:15 AM	#3
johngalt47 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

28th March 2007, 10:46 AM	#4
Ron E diyAudio Member 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

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search


	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

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?
Register to Participate Search Privacy Statement Contact Us	Frequently Asked Questions Did you forget your password? Mark Forums Read