| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming a dynamic range then apply it to a chart
Is there a way to programmatically setup a dynamic range (ie - a5:a2000,
c5:c2000) and then apply it to a chart? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Programming a dynamic range then apply it to a chart
Take a look at the Dynamic chart links here for more info
http://peltiertech.com/Excel/Charts/Dynamics.html "Mark Ivey" wrote: Is there a way to programmatically setup a dynamic range (ie - a5:a2000, c5:c2000) and then apply it to a chart? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Programming a dynamic range then apply it to a chart
I have looked through Jon's website before. It still does not get into the
detail I am looking for with VBA and creating a dynamic range. Does anyone have any good resources on this topic? Thanks in advance, Mark Ivey "Barb Reinhardt" wrote in message ... Take a look at the Dynamic chart links here for more info http://peltiertech.com/Excel/Charts/Dynamics.html "Mark Ivey" wrote: Is there a way to programmatically setup a dynamic range (ie - a5:a2000, c5:c2000) and then apply it to a chart? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Programming a dynamic range then apply it to a chart
Most speak of a dynamic range as a defined name (insert=Name=Define) with
a refers to like =offset(Sheet1!$A$1,0,0,CountA(Sheet1!$A:$A),1) What are you talking about. -- Regards, Tom Ogilvy "Mark Ivey" wrote in message ... I have looked through Jon's website before. It still does not get into the detail I am looking for with VBA and creating a dynamic range. Does anyone have any good resources on this topic? Thanks in advance, Mark Ivey "Barb Reinhardt" wrote in message ... Take a look at the Dynamic chart links here for more info http://peltiertech.com/Excel/Charts/Dynamics.html "Mark Ivey" wrote: Is there a way to programmatically setup a dynamic range (ie - a5:a2000, c5:c2000) and then apply it to a chart? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Programming a dynamic range then apply it to a chart
Tom,
That is exactly what I am talking about... Do you know of a method to do this programmatically and then apply it to an embedded chart? Thanks in advance, Mark Ivey "Tom Ogilvy" wrote in message ... Most speak of a dynamic range as a defined name (insert=Name=Define) with a refers to like =offset(Sheet1!$A$1,0,0,CountA(Sheet1!$A:$A),1) What are you talking about. -- Regards, Tom Ogilvy "Mark Ivey" wrote in message ... I have looked through Jon's website before. It still does not get into the detail I am looking for with VBA and creating a dynamic range. Does anyone have any good resources on this topic? Thanks in advance, Mark Ivey "Barb Reinhardt" wrote in message ... Take a look at the Dynamic chart links here for more info http://peltiertech.com/Excel/Charts/Dynamics.html "Mark Ivey" wrote: Is there a way to programmatically setup a dynamic range (ie - a5:a2000, c5:c2000) and then apply it to a chart? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Programming a dynamic range then apply it to a chart
Once you've defined the dynamic range, you don't need to redefine it. This
is what you'll need to add for your X or Y values for a workbook range. =Workbook.xls!NamedRange "Mark Ivey" wrote: Tom, That is exactly what I am talking about... Do you know of a method to do this programmatically and then apply it to an embedded chart? Thanks in advance, Mark Ivey "Tom Ogilvy" wrote in message ... Most speak of a dynamic range as a defined name (insert=Name=Define) with a refers to like =offset(Sheet1!$A$1,0,0,CountA(Sheet1!$A:$A),1) What are you talking about. -- Regards, Tom Ogilvy "Mark Ivey" wrote in message ... I have looked through Jon's website before. It still does not get into the detail I am looking for with VBA and creating a dynamic range. Does anyone have any good resources on this topic? Thanks in advance, Mark Ivey "Barb Reinhardt" wrote in message ... Take a look at the Dynamic chart links here for more info http://peltiertech.com/Excel/Charts/Dynamics.html "Mark Ivey" wrote: Is there a way to programmatically setup a dynamic range (ie - a5:a2000, c5:c2000) and then apply it to a chart? |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Programming a dynamic range then apply it to a chart
Thisworkbook.Names.Add Name:="XAxis", _
Refersto:="=offset(Sheet1!$A$1,0,0,CountA(Sheet1!$ A:$A),1)" ActiveChart.SeriesCollection(1).XValues = "=Book2!XAxis" If your workbook was named mybook.xls it would be ActiveChart.SeriesCollection(1).XValues = "=MyBook.xls!XAxis" -- Regards, Tom Ogilvy "Mark Ivey" wrote in message ... Tom, That is exactly what I am talking about... Do you know of a method to do this programmatically and then apply it to an embedded chart? Thanks in advance, Mark Ivey "Tom Ogilvy" wrote in message ... Most speak of a dynamic range as a defined name (insert=Name=Define) with a refers to like =offset(Sheet1!$A$1,0,0,CountA(Sheet1!$A:$A),1) What are you talking about. -- Regards, Tom Ogilvy "Mark Ivey" wrote in message ... I have looked through Jon's website before. It still does not get into the detail I am looking for with VBA and creating a dynamic range. Does anyone have any good resources on this topic? Thanks in advance, Mark Ivey "Barb Reinhardt" wrote in message ... Take a look at the Dynamic chart links here for more info http://peltiertech.com/Excel/Charts/Dynamics.html "Mark Ivey" wrote: Is there a way to programmatically setup a dynamic range (ie - a5:a2000, c5:c2000) and then apply it to a chart? |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Programming a dynamic range then apply it to a chart
Also, maybe something he
http://support.microsoft.com/default...40&Product=xlw XL97: How To Create a Dynamic Chart Using Visual Basic http://support.microsoft.com/default...80&Product=xlw XL2000: How to Use Visual Basic to Create a Dynamic Chart http://support.microsoft.com/default...55&Product=xlw Using Visual Basic to Create a Chart Using a Dynamic Range -- Regards, Tom Ogilvy "Mark Ivey" wrote in message ... Tom, That is exactly what I am talking about... Do you know of a method to do this programmatically and then apply it to an embedded chart? Thanks in advance, Mark Ivey "Tom Ogilvy" wrote in message ... Most speak of a dynamic range as a defined name (insert=Name=Define) with a refers to like =offset(Sheet1!$A$1,0,0,CountA(Sheet1!$A:$A),1) What are you talking about. -- Regards, Tom Ogilvy "Mark Ivey" wrote in message ... I have looked through Jon's website before. It still does not get into the detail I am looking for with VBA and creating a dynamic range. Does anyone have any good resources on this topic? Thanks in advance, Mark Ivey "Barb Reinhardt" wrote in message ... Take a look at the Dynamic chart links here for more info http://peltiertech.com/Excel/Charts/Dynamics.html "Mark Ivey" wrote: Is there a way to programmatically setup a dynamic range (ie - a5:a2000, c5:c2000) and then apply it to a chart? |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Programming a dynamic range then apply it to a chart
Outstanding information...
Thanks a million Tom... "Tom Ogilvy" wrote in message ... Thisworkbook.Names.Add Name:="XAxis", _ Refersto:="=offset(Sheet1!$A$1,0,0,CountA(Sheet1!$ A:$A),1)" ActiveChart.SeriesCollection(1).XValues = "=Book2!XAxis" If your workbook was named mybook.xls it would be ActiveChart.SeriesCollection(1).XValues = "=MyBook.xls!XAxis" -- Regards, Tom Ogilvy "Mark Ivey" wrote in message ... Tom, That is exactly what I am talking about... Do you know of a method to do this programmatically and then apply it to an embedded chart? Thanks in advance, Mark Ivey "Tom Ogilvy" wrote in message ... Most speak of a dynamic range as a defined name (insert=Name=Define) with a refers to like =offset(Sheet1!$A$1,0,0,CountA(Sheet1!$A:$A),1) What are you talking about. -- Regards, Tom Ogilvy "Mark Ivey" wrote in message ... I have looked through Jon's website before. It still does not get into the detail I am looking for with VBA and creating a dynamic range. Does anyone have any good resources on this topic? Thanks in advance, Mark Ivey "Barb Reinhardt" wrote in message ... Take a look at the Dynamic chart links here for more info http://peltiertech.com/Excel/Charts/Dynamics.html "Mark Ivey" wrote: Is there a way to programmatically setup a dynamic range (ie - a5:a2000, c5:c2000) and then apply it to a chart? |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Programming a dynamic range then apply it to a chart
Take a look at:
http://www.bmsltd.co.uk/Excel/Default.htm Look for funchrt7.zip on the page. A very neat little example of charting with dynamic ranged names. Here's its description: "This spreadsheet demonstrates the power arising from using defined names as the source for your charts. When charting data from a large data set (say more than a few hundred data points), it can help to be able to zoom and scroll through the data. I.e. to set a window of say 50 items and scroll through the data showing only that number of items. This example uses a chart and two scroll bars (for the zooming and scrolling), while the link from the scroll bar values to the chart display is done entirely using defined names - no code required." With a little tweaking, I was also able to add a toolbar to change data series. On Nov 4, 3:39 pm, "Mark Ivey" wrote: Is there a way to programmatically setup a dynamic range (ie - a5:a2000, c5:c2000) and then apply it to a chart? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| dynamic range and chart - big help!! | Excel Worksheet Functions | |||
| Chart empty with new data in the dynamic range chart. | Excel Discussion (Misc queries) | |||
| dynamic chart range with VBA | Excel Programming | |||
| VBA code needed to apply formula to each value in a dynamic range! | Excel Programming | |||
| Dynamic Chart Range and Chart Update | Excel Programming | |||
Linear Mode
