Multi Axis Pivot Chart
in [General]
|
From: Angela on 26 Feb 2010 11:29 Is it possible to chart 2 items with different axis on a Pivot Chart? I want an Average Time line plot (value axis on Left) and a Count of Inspections bar plot (value axis on Right). I have the information in a Pivot Chart and all items charted but when I add a Series Group with the Avg Time and add another Series Group with the Count of Inspections, adding a Value Axis on the left it usually changes both Value Axis to the same value. Also as I change the Dates or other specifics it seems like the data points lose what Value Axis they are connected to. This can easily be done in Excel but I can't find any information on how to do it in Access.
From: a a r o n . k e m p f on 26 Feb 2010 22:20 the other option that you have with pivotTables is this: a) insert, ActiveX control b) Office PivotTable using that control you have a lot more flexibility, in my opinion I love Office Web Components, by far the best product that MS ever came out with On Feb 26, 8:29 am, Angela <Ang...(a)discussions.microsoft.com> wrote: > Is it possible to chart 2 items with different axis on a Pivot Chart? I want > an Average Time line plot (value axis on Left) and a Count of Inspections bar > plot (value axis on Right). > > I have the information in a Pivot Chart and all items charted but when I add > a Series Group with the Avg Time and add another Series Group with the Count > of Inspections, adding a Value Axis on the left it usually changes both Value > Axis to the same value. Also as I change the Dates or other specifics it > seems like the data points lose what Value Axis they are connected to. > > This can easily be done in Excel but I can't find any information on how to > do it in Access.
From: Tony Toews [MVP] on 26 Feb 2010 23:36 "a a r o n . k e m p f @ g m a i l . c o m" <aaron.kempf(a)gmail.com> wrote: >the other option that you have with pivotTables is this: > >a) insert, ActiveX control >b) Office PivotTable > >using that control you have a lot more flexibility, in my opinion > >I love Office Web Components, by far the best product that MS ever >came out with "The Office Web Components technology is deprecated. This means that only security fixes are being made to all versions of OWC, and no future versions of OWC will be produced. " http://support.microsoft.com/kb/972129 Tony -- Tony Toews, Microsoft Access MVP Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ For a convenient utility to keep your users FEs and other files updated see http://www.autofeupdater.com/ Granite Fleet Manager http://www.granitefleet.com/
From: a a r o n . k e m p f on 2 Mar 2010 22:11 I'm not so sure that anything is officially depecrated. OWC is still-- _TODAY_ being shipped in a half dozen BRAND NEW Microsoft products. Thanks -Aaron On Feb 26, 8:36 pm, "Tony Toews [MVP]" <tto...(a)telusplanet.net> wrote: > "a a r o n . k e m p f @ g m a i l . c o m" <aaron.ke...(a)gmail.com> wrote: > > >the other option that you have with pivotTables is this: > > >a) insert, ActiveX control > >b) Office PivotTable > > >using that control you have a lot more flexibility, in my opinion > > >I love Office Web Components, by far the best product that MS ever > >came out with > > "The Office Web Components technology is deprecated. This means that only security > fixes are being made to all versions of OWC, and no future versions of OWC will be > produced. " > > http://support.microsoft.com/kb/972129 > > Tony > -- > Tony Toews, Microsoft Access MVP > Tony's Main MS Access pages -http://www.granite.ab.ca/accsmstr.htm > Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/ > For a convenient utility to keep your users FEs and other files > updated seehttp://www.autofeupdater.com/ > Granite Fleet Managerhttp://www.granitefleet.com/
From: George Hepworth on 3 Mar 2010 12:50 http://support.microsoft.com/kb/972129 Article ID: 972129 - Last Review: June 10, 2009 - Revision: 1.0 "...The Office Web Components technology is deprecated. This means that only security fixes are being made to all versions of OWC, and no future versions of OWC will be produced. If you are using OWC, you should start to migrate to a new technology as soon as possible...." You can check the KB for details on when support has ended, or will end, for each version of OWC. "a a r o n . k e m p f @ g m a i l . c o m" <aaron.kempf(a)gmail.com> wrote in message news:2221dd70-59b3-4b19-a590-78493205666f(a)z1g2000prc.googlegroups.com... > I'm not so sure that anything is officially depecrated. > > OWC is still-- _TODAY_ being shipped in a half dozen BRAND NEW > Microsoft products. > > Thanks > > -Aaron > > > > On Feb 26, 8:36 pm, "Tony Toews [MVP]" <tto...(a)telusplanet.net> wrote: >> "a a r o n . k e m p f @ g m a i l . c o m" <aaron.ke...(a)gmail.com> >> wrote: >> >> >the other option that you have with pivotTables is this: >> >> >a) insert, ActiveX control >> >b) Office PivotTable >> >> >using that control you have a lot more flexibility, in my opinion >> >> >I love Office Web Components, by far the best product that MS ever >> >came out with >> >> "The Office Web Components technology is deprecated. This means that only >> security >> fixes are being made to all versions of OWC, and no future versions of >> OWC will be >> produced. " >> >> http://support.microsoft.com/kb/972129 >> >> Tony >> -- >> Tony Toews, Microsoft Access MVP >> Tony's Main MS Access pages -http://www.granite.ab.ca/accsmstr.htm >> Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/ >> For a convenient utility to keep your users FEs and other files >> updated seehttp://www.autofeupdater.com/ >> Granite Fleet Managerhttp://www.granitefleet.com/ >
|
Next
|
Last
Pages: 1 2 3 Prev: Conditional format duplicates Next: new to access - please forgive ignorance |