|Without knowing anything about how your data is laid out or what you are trying to plot, it's hard to offer a specific solution. We may need some more detail.|
How about this...
If the original data is in A1:A400000, create a "helper column" with the formulas:
Now plot the helper column.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.