Interesting Chart question... 1

[TheRealDeal]

I have the 12 months as columns and I want to be showing only 4 at a time on the line chart. Can I set the chart to only display 4 months at time with the option of scrolling right or left to display the other months?

 

[SkipVought]

Hi

This is a PRIME example for the OFFSET worksheet function.

=OFFSET(Sheet2!$B$2,0,ColOff,1,4)

for the series in row 2

where ColOff is the month offset number

use in the Y-Axis Data source

In the x category use

=OFFSET(Sheet2!$B$1,0,ColOff,1,4)



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[jdhilljr]

http://www.procollectortips.com/graph.xls

Jim

 

[uthomsst]

Hi

I am trying produce a stacked bar graph but I want the bars across the x axis to also be to scale.

i.e. If bar one has a value of 100 and bar 2 has a value of 50 I want to display the first bar as twice the width of the second bar.

Anyone got any idea ho to do this.

Thanks

 

[xlbo]

And how is this anything to do with the thread above ???
Please start a new thread and read the forum FAQs.

Rgds, Geoff

"Errors have been made....Others will be blamed"

Please read FAQ222-2244 before you ask a question