viewing big charts
Why not just embed the chart in a worksheet instead of creating a chart sheet
and size it manually to suit? If you don't want someone to be able to scroll
beyond the limits of the chart then add the following code to the
ThisWorkbook code module:
Private Sub Workbook_Open()
Sheets("Sheet1").ScrollArea = "A1:T50"
End Sub
Change the referenced range (here "A1:T50") to fit the range occupied by the
chart. You will likely have to adjust the row height, column widths and chart
dimensions slightly so that the user can't see any leftover worksheet when
scrolling to the limits of the range.
Regards,
Greg
"inquirer" wrote:
Is there any way to create large charts in excel, ie those that exceed the
screen size, and view them by creating scroll bars and scrolling right/left,
up/down ?
Chris
|