Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-27-2010, 02:56 PM
niss3 niss3 is offline Creating Scatter XY chart in Excel 2007, modifying the Y axsis Windows XP Creating Scatter XY chart in Excel 2007, modifying the Y axsis Office 2007
Novice
Creating Scatter XY chart in Excel 2007, modifying the Y axsis
 
Join Date: Oct 2010
Posts: 1
niss3 is on a distinguished road
Default Creating Scatter XY chart in Excel 2007, modifying the Y axsis


Hello!


I would be really really greatful if someone could guide me through the process of editing the Y axsis of a chart so I can customize it as I would like it to be.


I've searched through multiple sites for help or tutorials and I have spent several hours trying to figure this out, but I'm stuck in my process.
I want to create a simple line with Data1 to Data2. Data1 can simply be 0, and Data2 any number, like 100.

And then, I want the Y axsis to show another value with certain invervalls. In this example I would like the Y axsis to be "time". And the time should go from 0 to 60, with 3 secound intervalls so I can see where the line is at exactly 36 secounds.


Now how can I do this? I've tried and tried in any way I can imagine. I've tried to customize and I've tried getting help from people who use excel 2003. Nothing have worked and this is my last resort. Please help me!
Reply With Quote
  #2  
Old 10-27-2010, 07:41 PM
Kimberly Kimberly is offline Creating Scatter XY chart in Excel 2007, modifying the Y axsis Windows 7 Creating Scatter XY chart in Excel 2007, modifying the Y axsis Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

Put numeric data down a column.
In the column to the right, put the numbers that represent number of seconds.
Select the range and insert a Scatter with only markers
Double-click on the vertical axis and change the Major Unit to Fixed and 3.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Chart title problem skoley Excel 0 07-27-2010 06:23 AM
modifying index styles alpruett Word 0 04-23-2010 12:52 PM
Creating Chart using VB textbox value shyler82 Word VBA 0 03-12-2010 06:56 PM
Creating Scatter XY chart in Excel 2007, modifying the Y axsis Uniform color for scatter plot with 2 series gramentz Excel 2 01-17-2010 08:21 AM
Creating Scatter XY chart in Excel 2007, modifying the Y axsis Paste chart from Excel bielak01 Word 4 04-29-2009 02:42 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 11:20 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft