Graph Macro Selecting Range

[foxy_420]

Hey guys,

I am in some major need of help and would greatly appreciate some assistant. I am hoping there is a real quick fix for this.

I was initially generating several graphs from a set of data based on a range:

Please Login or Register  to view this content.

the x-axis were:

Please Login or Register  to view this content.

This works great...However, the issue is I need to rearrange the x-axis values to something like:

Please Login or Register  to view this content.

I thought it would be an easy fix to change the range , by putting this:

Please Login or Register  to view this content.

However this is not the case. The problem is the X-axis values change (as they should) but the graph data does not align with them now. It appears as when selecting a range, the data cannot go back and forth between columns (ie. A1,D1,B1 etc..)

Is there a quick solution to fixing the "Range" data without rewriting the entire code?
Workbook.xlsm

[smde]

You might - try this :

Please Login or Register  to view this content.

but I normally use the followng technique :

Please Login or Register  to view this content.

Cheers