A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Y Axis Shows Date, rather than Value ? Help Please.



 
 
Thread Tools Display Modes
  #1  
Old December 9th 16, 12:36 PM posted to microsoft.public.excel.misc
Bob[_19_]
external usenet poster
 
Posts: 72
Default Y Axis Shows Date, rather than Value ? Help Please.

Hello,

Running Excel 2007 and W10

Want to make a "simple" plot of blood p readings.

X axis to have date
Y axis to have value.

Have selected a Scatter graph format.

No matter what I seem to do, the Y axis also shows the date, rather than
the value. (X axis shows date too, which is fine and what I want)

How, please can I get the Y axis to show the value.

Have tried just about everything.
I've selected the data columns for the dates and values, but it refuses
to plot anything but the dates in the Y.

Funny, but the resultant graph looks just fine, if you "imagine" the Y
axis as having values rather than the dates.

Thoughts, Please ?

Thanks,
Bob
Ads
  #2  
Old December 9th 16, 12:57 PM posted to microsoft.public.excel.misc
Claus Busch
external usenet poster
 
Posts: 3,448
Default Y Axis Shows Date, rather than Value ? Help Please.

Hi Bob,

Am Fri, 9 Dec 2016 07:36:04 -0500 schrieb Bob:

> Want to make a "simple" plot of blood p readings.
>
> X axis to have date
> Y axis to have value.
>
> Have selected a Scatter graph format.
>
> No matter what I seem to do, the Y axis also shows the date, rather than
> the value. (X axis shows date too, which is fine and what I want)


if the date column is the most left column the date comes automatically
to the x axis.
If not, then select the chart => Select Data and change in the dialog
box the series of the legend entries and and the horizontal axis.
Have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgYI-fCz3P6SW4iUuyQ


Regards
Claus B.
--
Windows10
Office 2016
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Hovering Over the data point shows different X-Axis Melissa Charts and Charting in Excel 0 February 25th 09 03:46 PM
How do I force a secondary horizontal axis to act as a date axis? The_Tim Charts and Charting in Excel 5 July 6th 07 05:18 AM
ONLY PART OF MY TYPED IN Y-AXIS LABEL SHOWS UP ON THE CHART christineST Charts and Charting in Excel 2 January 21st 07 06:00 AM
Excel: I enter date and format for date, but shows as number spohar Excel Discussion (Misc queries) 2 March 10th 06 08:40 PM
why my date shows up as 12:00:00 AM? Papa Jonah Excel Programming 2 November 30th 04 03:38 PM


All times are GMT +1. The time now is 11:22 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.