Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / October 2007

Tip: Looking for answers? Try searching our database.

Correlation Charting

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
KenCanuck - 31 Oct 2007 16:53 GMT
How do I get two colums of data to chart next to each other when their vales
are very different, so the Y axis is only charting the bigger value.  Ex.
Sales values in weeks 1 - 8 range from 50,000 - 100,000 and hours worked
range from 30 -50.  I want to show the correlation on the line chart, but it
puts the hours worked data as a straight line at the bottom of the chart
because the values a re so low compared to the sales data.
Andy Pope - 31 Oct 2007 17:20 GMT
Hi,

Select one of the series and on the Format dialog, CTRL+1, Axis tab set the
series to the secondary axis.

Cheers
Andy

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

> How do I get two colums of data to chart next to each other when their
> vales
[quoted text clipped - 4 lines]
> puts the hours worked data as a straight line at the bottom of the chart
> because the values a re so low compared to the sales data.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.