hello every one
i want represent time
7:00 7:30 8:00 8:30 9:00 9:30 10:00 10:30 11:00 11:30 12:00 12:30 1:00 1:30 2:00 2:30 3:00 3:30 4:00 4:30
in x axis
and the value in y axis
52.2 174.1 407.8 636.1 1084.4 1394.3 1615 1882.4 2302.4 2787.1 3260.5 3632 3986.1 4391 4753.3 5225 5768.7 6581.4 6663.2 6881.8
but when i plot this the all values not represent in the curve
only the first ten values represent
please help me
the file is attached below
What process are you following to create the chart?
I'm using Excel 2010, and the following plots all values with no issues:
- Select cells A1 to T2
- On the Insert tab of the ribbon select the line chart type you want
The first twelve are represented (7:00am through 12:30pm).Originally Posted by sadq
The remainder are also represented, as implied by the sharp line to the left.
You don't see them because (a) you mistakenly (?) entered them as 1:00am through 4:30am instead of PM in M1:T1; and (b) you need to adjust the Minimum for the x-axis (right-click on the x-axis labels, click on Format Axis, and perhaps select Auto for Minimum).
Last edited by joeu2004; 09-21-2014 at 10:29 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks