Hello, I have a simple xy scatter plot with data comprising an incremental y axis (depth) and an x axis with irregular data and some blanks.
Please see attached sheet.
The problem is that the x-axis is not plotting correctly and is plotting values from a source that I cannot determine - possible the value order number?
Possibly due to 'blank' values but tried several workarounds to no avail...
Any help appreciated.
Steven
Hi,
Odd behavior indeed!
If you put this
Formula:
Please Login or Register to view this content.
in C2 and copy it down, then change the X data source to column C it should sort out the issue for you.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks