I want "Infinite" horizontal scrolling for a chart.

  • Thread starter Thread starter Nick Michell
  • Start date Start date
N

Nick Michell

Hi,

I have a worksheet containing daily data relating to web site page
hits and want to chart this as an open-ended graph on a Chart sheet.

For example, column A contains the current date, column B the number
of hits for Page 1, column C hits for Page 2, etc. Date is the y-axis,
counts are charted on the x-axis. I add the data on a daily basis and
extend the data range by seven days at the start of each week.

How can I make the chart wider than the sheet, and avoid having the
data horizontally squished into a single pane. In other words, I want
a chart sheet to behave as a Worksheet in terms of scrolling. I know
I'll lose the y-axis legends on a right scroll, but I can live with
that.

TIA
 
Hi Frank,

Thanks for those links - lots of useful stuff but none of it gives me
a solution.

Just to restate my requirement, when I dynamically extend my x-axis
data range, I want the horizontal "scale" to remain the same (1cm per
day, or whatever) and for the chart to extend beyond the right-hand
edge of the sheet pane, requiring a scroll to bring the new result
into view.
 
Hi
AFAIK you can't exactly achieve this kind of chart. What is possible
(and shown on Jon Peltier's site) is to create a dynamic chart, use a
scrollbar and scroll through your data range

--
Regards
Frank Kabel
Frankfurt, Germany


Nick said:
Hi Frank,

Thanks for those links - lots of useful stuff but none of it gives me
a solution.

Just to restate my requirement, when I dynamically extend my x-axis
data range, I want the horizontal "scale" to remain the same (1cm per
day, or whatever) and for the chart to extend beyond the right-hand
edge of the sheet pane, requiring a scroll to bring the new result
into view.
Click to expand...
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html
 
Nick -

An alternative approach: Embed the chart on the worksheet, zoom out to
50% or 25% (or switch to page break preview), and stretch the chart
widthwise as far as you'd like.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top