Re: [MS_AccessPros] VBA... but excel secondary axix

oh! I should not be using ActiveChart ! Better to reference the chart
using ChartObject ...

xlWs.ChartObjects.Count
is all the ChartObjects on a worksheet -- then, I think you can use
.ChartObjects(i) -- didn't test it though.. I know you can do this:

dim cht As ChartObject
For Each cht In xlWs.ChartObjects

WHERE
xlWs is the worksheet object variable
i is the chart number

warm regards,
crystal

On 10/14/2015 7:25 PM, crystal 8 strive4peace2008@yahoo.com
[MS_Access_Professionals] wrote:
> Hi Liz,
>
> thanks, Liz ... I did as Duane suggested and recorded a macro :)
>
> try:
> .ActiveChart.FullSeriesCollection(#).AxisGroup = 2
>
> WHERE
> # is the series number
>
> here are some very helpful pages on Excel charting:
>
> Jon Peltier's Excel Charting Pages
> http://peltiertech.com/Excel/ChartsHowTo/QuickChartVBA.html
>
> Charting Tools for Excel by Ed Fererro
> http://www.edferrero.com/charting.aspx
>
> I haven't checked this out as much, but it is on my list to look at:
>
> Microsoft: Creating PivotTable Reports and Charts with VBA in Excel 2010
> https://msdn.microsoft.com/en-us/library/office/hh243933%28v=office.14%29.aspx
>
> ... and remember the Object Browser! F2 when you are in VBA, then select
> Chart in the Classes list. When you see something interesting, press F1
> for Help
>
> warm regards,
> crystal
>
> ~ have an awesome day ~
>
>
> On 10/14/2015 4:52 PM, Duane Hookom duanehookom@hotmail.com
> [MS_Access_Professionals] wrote:
>> Liz,
>>
>>
>> Did you attempt to record a macro in Excel and then use the code?
>>
>>
>> Duane Hookom,, MVP
>>
>> MS Access
>>
>> ________________________________
>>> To: MS_Access_Professionals@yahoogroups.com
>>> From: MS_Access_Professionals@yahoogroups.com
>>> Date: Wed, 14 Oct 2015 20:39:23 +0000
>>> Subject: [MS_AccessPros] VBA... but excel secondary axix
>>>
>>>
>>>
>>>
>>> Pros, and well, I bet Crystal knows this…
>>>
>>>
>>>
>>> I'm programmatically trying to create a secondary axis to an excel
>>> chart from an Access DB (there's the Access – ha!) and this is not
>>> working:
>>>
>>>
>>>
>>> .activechart.HasAxis(xlValue, xlSecondary) = True
>>>
>>> .activechart.SetElement (msoElementSecondaryValueAxisShow)
>>>
>>>
>>>
>>> The google results also show xlCategory instead of xlValue but they
>>> both don't compile as they are being considered some type of undeclared
>>> variable.
>>>
>>>
>>>
>>> What am I missing?
>>>
>>>
>>>
>>> Respectfully,
>>>
>>> Liz Ravenwood
>>>
>>> Programmer / Analyst
>>>
>>> B/E Aerospace | Super First Class Environments
>>>
>>>
>>>
>>> 1851 S Pantano Road | Tucson, Arizona 85710
>>>
>>> Office +1.520.239.4808 | Internal 814-4808
>>>
>>> beaerospace.com
>>>
>>> Passion to Innovate. Power to Deliver
>>>
>>>
>>>
>>>
>>> This email (and all attachments) is for the sole use of the intended
>>> recipient(s) and may contain privileged and/or proprietary information.
>>> Any unauthorized review, use, disclosure or distribution is prohibited.
>>> If you are not the intended recipient, please contact the sender by
>>> reply e-mail and destroy all copies of the original message.
>>>
>>>
>>>
>> ------------------------------------
>>
>> ------------------------------------
>>
>>
>> ------------------------------------
>>
>> Yahoo Groups Links
>>
>>
>>
>
>
> ------------------------------------
>
> ------------------------------------
>
>
> ------------------------------------
>
> Yahoo Groups Links
>
>
>



------------------------------------

------------------------------------


------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/