Formatting values on a chart axis

------------------------------------------------------------------------
A poll associated with this post was created, to vote and see the
results, please visit http://www.excelforum.com/showthrea...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.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

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

In article <Jody1910.x9hcz@excelforum-nospam.com>,
Jody1910.x9hcz@excelforum-nospam.com says...
>
> ------------------------------------------------------------------------
> A poll associated with this post was created, to vote and see the
> results, please visit http://www.excelforum.com/showthrea...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.
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~View and post usenet messages directly from http://www.ExcelForum.com/
>
>

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

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

Maurice wrote:
>
> alternatively you may like to attach the file for others to look at
>

Please don't encourage someone to attach files to this forum.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______