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

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

<*> 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/