Change the characteristics of X Axis

  • Thread starter Thread starter chimp
  • Start date Start date
C

chimp

i have a graph that i hightlight data by week, and i would like t
indicate a seperator per week.

each week displays 3 pieces of data on the chart

eg

week 401 ( this is week 1 in 2004)

would appear 3 times

then week 402 would have three pieces of data and so on, but i want
clear indicator of the week change, i am easy on how this i
done....colour a line or and other suggestion.

here is a screenshot of my chart, hopefully you will see what i a
waffling on about.

[image: http://members.lycos.co.uk/redtilefc/graph.jpg]

my setup is as follows:

so i am not sure how i am gonna modify it to how you have it, this i
how it is exported from MS Access, and wouldn't know how to modify i
to like you have it.

[image: http://members.lycos.co.uk/redtilefc/data structure.jpg]

Cheers

And
 
Insert a blank column between Week Number and Event Code.
Add a heading, e.g. Week
In cell B2, enter the formula: =IF(A2=A1,"",A2)
Copy the formula down to the last row of data
Use column B, instead of column A, when creating the chart.
i have a graph that i hightlight data by week, and i would like to
indicate a seperator per week.

each week displays 3 pieces of data on the chart

eg

week 401 ( this is week 1 in 2004)

would appear 3 times

then week 402 would have three pieces of data and so on, but i want a
clear indicator of the week change, i am easy on how this is
done....colour a line or and other suggestion.

here is a screenshot of my chart, hopefully you will see what i am
waffling on about.

[image: http://members.lycos.co.uk/redtilefc/graph.jpg]

my setup is as follows:

so i am not sure how i am gonna modify it to how you have it, this is
how it is exported from MS Access, and wouldn't know how to modify it
to like you have it.

[image: http://members.lycos.co.uk/redtilefc/data structure.jpg]

Cheers

Andy
Click to expand...
 
Back
Top