Formatting values on a chart axis

  • Thread starter Thread starter Jody1910
  • Start date Start date
J

Jody1910

------------------------------------------------------------------------
A poll associated with this post was created, to vote and see the
results, please visit http://www.excelforum.com/showthread.php?threadid=169056
------------------------------------------------------------------------
Question: How often do u respond to postings

- Never
- Only if it is the area in which i am interested
- Rarely, No time to respond
- Whenever i can help
------------------------------------------------------------------------

Hi,

I am kinda new here. But i have an assignment which is just impossible.
I am using MS Excel xp, and the thing is i want to show the changes in
a variable as time changes, but time is not to be mapped, but we are to
use a line chart to do it. And it is required that the time increases
by 1 sec (fomr 0 to 11), and the graph would show the variable's
movement. However, the computer gives me difault valuse for time and
when i put how much i want it to increase by the are is so small that
it doesn't show , but instead looks like a line.


What can i do????????????

I really need help my work is due on monday and the chart is the only
thing left giving me a headache.
 
In one column put in the time in seconds, 0, 1,..., 11. In the
adjacent column to the right put in the value of the variable. Plot
the two columns in a Line chart. If you want to 'steps' rather than
inclined lines connecting the points, see the Excel | Charts | 'Step
Chart' tutorial on my web site.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Jody

Try right clicking on the axis and then select scale, and set smalle
values

alternatively you may like to attach the file for others to look a
 
Back
Top