Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 24th 12, 03:43 PM
Junior Member
 
First recorded activity by ExcelBanter: Oct 2012
Posts: 1
Default How do I create a scrolling line chart?

Hi-
I have a line chart that includes five columns worth of data for 365 days. The chart is clearly VERY crowded, and I need to find a way to just show 7-14 days of data at at time and be able to scroll through the days. I have found a few posts about this online that seem to somehow use the OFFSET function, but I just can't seem to get it to work. I am using Excel 2007. I would GREATLY appreciate any help anyone can offer. Thanks!

Meg

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
can't create a simple Line Chart Ruuudy New Users to Excel 2 July 15th 09 12:53 PM
create line chart with two axises in Pivot Chart HuaXC Charts and Charting in Excel 1 February 21st 07 09:28 PM
how do create a line/scatter chart Naomi Charts and Charting in Excel 1 January 9th 07 02:06 PM
How do I create a Line Chart (Special) Big H Charts and Charting in Excel 1 November 26th 06 07:45 PM


All times are GMT +1. The time now is 06:03 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017