Attached is an image of a chart whose x-axis input values are YYYYMMDD but the displayed chart format is YYYYM000 ... thus probably leading to the introduction of the erroneous slightly inclined line in the middle of the chart.
I figure it is probably a formatting issue but thus far no luck in changing the date format to solve the problem
the second attachment is an image of some of the chart input x-axis date values.
any comments, suggestions, etc, will be much appreciated.
attached is the image of the chart which did not get attached previously,
It certainly looks a bit odd. However, without an Excel sheet to work with, it's hard to say what's wrong. Can you post a sheet?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
attached is the spreadsheet [I hope]
appears you are in Ireland. am googling it...looks interesting
thanks for the help
Spreadsheet did not attach.
It appears to me that you are plotting the data on a scatter plot. It also appears that these "dates", instead of being stored in a date format that Excel can recognize, are being stored as numbers (the first entry in your picture would be seen by Excel as 20 million, 60 thousand, 103). A scatter plot treats the X values as numbers exactly as Excel sees the number, so you get several data points at 20.06 million (which you think means june 2006 but Excel does not see them the same way), then several data points at 20.07 million, and so on.
My first thought would be to get these into Excel as either text strings or in a format the Excel will recognize as a date.
You could try using a line chart (category axis -- not date axis) and see if you like that result. A category axis, though, will not scale the dates along a date scale. It should not be important if you have an entry for each day, but could be problematic if you don't have an entry for each day.
Originally Posted by shg
I tried again to upload the spreadsheet. if it doesn't appear with this reply
please give me some attachment directions. this is ridiculous ... I have done it many
times previously.
I just found some attachment directions in FAQ - SO MAYBE I WILL SUCCEED ON MY NEXT POST.
FROM FAQ
How do I attach a file to a post?
To attach a file to your post, you need to be using the main 'New Post' or 'New Thread' page and not 'Quick Reply'.
To use the main 'New Post' page, click the 'POST REPLY' BUTTON in the relevant thread.
I got the above directions from FAQ - but I cannot find a 'POST REPLY' BUTTON????
please help
Try the "Go Advanced" button next to the quick reply button. That page should have a "manage attachments" button/link where you can upload attachments
thanks mrshorty,
I got a message 'your file of 3.84 MB bytes exceeds the forum's limit of 1,000.0 KB for this file type.'
should I reduce the size by reducing the number of rows, or perhaps somehow send it as a zip file, or .....?
It doesn't seem to me that this kind of question needs every single data point to explain the problem. I would expect that a dozen or so representative data points would illustrate the problem, so I would vote for reducing number of rows in the file you wish to upload.
yep, I agree...makes sense to me.
please see attachment, and thanks again for the help.
I just noticed that the chart on the graph sheet does not respond to a select data request.
the date column used by the chart for the xaxis is column AX on the analysis sheet.
there are no dates in column ax ,not ones excel sees as a date anyway
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
i will try to change column AX to a date format to see if that makes it work.
thanks.
The example file in this help file (http://office.microsoft.com/en-us/ex...2402#BMexample ) has an example using the DATE() function for converting yyyymmdd data into something Excel can recognize as a date. I expect that,once you get these data in there as real dates, the charting issue will resolve itself.
for the record and to whom it may concern---
I sent a reply last night thanking everyone, awarding everyone ''add reputations'' and then marking the thread closed.
experience told me to log off and on to the website and it was definitely there at the time.
also, instant email alerts to replies sometimes work and sometimes not.
peace
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks