Can’t get chosen range on x axis.

[theherbalist]

Hi there, I’m really new to this whole vba thing so please be kind .

I’m trying to write a macro that selects a specific sheet, and then selects ranges on that sheet based on column title. With this selection I want it to draw a scatter graph. However, the problem I’m having is that once the graph is drawn the values on the x axis are only integers, not "time" which is the range of my choosing. Time is plotted as another series on the Y axis? How do I solve this? It’s also worth mentioning that this macro works on some files but not others, even though the files are identical in every way (e.g number of columns, column titles etc) except for the values within the cells and the number of cells with data.

here is the code:

Please Login or Register  to view this content.

[RudiS]

How does the chart turn out if you manually draw it up in a file where the macro is not running correctly?
Does it also turn out incorrectly with the time on the Y-Axis?

[theherbalist]

Hmm good point, unfortunately I don’t have access to that file right now, but i just tried it in a fake spreadsheet that I just mocked up and both using the macro and manually drawing the graph works. It makes no sense (to me) whit it would work on some files but no others.
Thanks for your reply.

[RudiS]

If it makes no sense on your side, it is even foggier on my side.
It could help to post a desensitized copy of your file so we can assist further.
Without knowing your file structure and the formats of your data, we can only guess.

[theherbalist]

Yeah I thought that would be the case. I’ll try and post a desensitized version tomorrow or at the weekend. As I said I don’t have access to those files right now. however if anyone can spot anything blatantly wrong with my cod ethen feel free to let me know.