Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Charting

Status
Not open for further replies.

tgmoon

Technical User
Jan 31, 2001
54
GB
Does anyone know if its possible to automatically control, not only the height of a bar chart, but also the width of the bar depending on data?

Thanks
 
not sure that I understand this but if you want to say show only show bars for week 1 to week 5 (because this week is week 5) then show bars for week 1 to week 6 next week, I have done this by setting the graph to named ranges and increasing the range automatically each week.

If this is what you need I will send a worked example

Regards

Keith
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top