On Mar 31, 10:20*pm, "Jon Peltier"
wrote:
If the numbers are in the order you want, then make a line chart rather than
an XY chart. The line chart treats everything, even numbers, as nonnumeric
labels.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.http://PeltierTech.com/WordPress/
_______
"Bobby" wrote in message
...
Could someone give my a hand on this:
I am trying to set a range on a graph but the result does not reflect
the range values.
Here is the code:
ActiveSheet.ChartObjects("Chart 1").Activate
With ActiveChart.SeriesCollection.NewSeries
*.Values = Sheets("Planif-plan").Range("H2:H79")
End With
I would like to see:
22 23 24 25 26 27 up to 52 and 1 2 3 4 up to 47
This represent 78 weeks of planning
What I get is:
1 to 78
Can this be fix?
Thank you!- Hide quoted text -
- Show quoted text -
Thank's Jon