Pivot chart values



  • 1. Column chart with 2 Y axis's
    I have two Y axis, the secondary is 10x the primary in values. The 1 data series plotted against the secondary axis shows up right on top of the 4 data series plotted against the primary axis. Is there some way to avoid this, so all 5 data series appear side by side with no overlap? Thanks!!! Norm PS Excel 2002 & WIndows 2000 Pro Father Guido I plan on living forever... so far, so good
  • 2. custom y error bars
    Does anybody know how to deal with a bug in excel? I have office vX for OS X.2.8 and I just updated office with the latest 10.1.5 update, but I still have this problem with trying to do custom error bars on a bar graph. It basically comes up with a 'formula error' and when i get rid of the error box, it highlights the name of the sheet as being the error. It doesn't do this on every single file, just selected ones, only I don't know how it selects these particular ones. It's extremely frustrating and I thought upgrading excel would fix the problem, but it hasn't.
  • 3. 3 bars (1st Y axis) 1 line (2nd Y axis) please help!!!!!
    I need to make a chart with 3 bars (profit), and a line (money lost %), i could make it with 2 bars, but i dont know if it possible to add 1 bar!!!! Please Help!!!!!! KARLA
  • 4. Column Column 2 axes
    Hi, How do I make a column-column graph but use 2 different y-axes? Thanks

Pivot chart values

Postby c2F6MjM2OQ » Wed, 04 Feb 2009 19:31:01 GMT

On my stacked column pivot chart I want to show on the 
data labels the percentage that make up the column and on my y axis the 
actual number can I show this?

Similar Threads:

1.Pivot Chart Value Axis Scaling Question

Question:  Is there a way with VBA to dynamically control the value axis
based on the data values being displayed at any given time?

Details:  I have a pivot chart that displays 3 data series.

Series 1 values range from 17 to 106.
Series 2 values range from 1 to 18.
Series 3 values range from 0 to 1.

When I display all three series on the chart, the value axis labels run from
1 to 120 with major unit lines at intervals of 20.

When I remove Series 1, the chart automatically adjusts itself and the
value axis labels run from 1 to 20 with lines at intervals of 2, thus
nicely accommodating the value ranges of Series 1 and Series 2.

All this is fine.  But when I remove Series 2, leaving only Series 3,
the labels run from 1 to 1.2 with interval spacing of .2.  Since these
values are counts, it makes little sense to show decimal values.

Can anyone provide advice on how to keep these axis labels from
showing decimal values, if a user removes Series 1 and Series 2?


- Bob

2.Pivot Chart Values

I want to see the value of a particular bar on a bar chart when I
hover the mouse over that bar.
How is this done?


3.Maintain colour changes in a Pivot Chart when changing Pivot value

How do i maintain colour changes and formatting in a Pivot Chart when I 
change or update the pivot table (or drop down boxes)?

4.chart from pivot data does not update x-axis bar chart values - bug

wondering if anyone can help with this unusual bug.

what i've got:
>> 4 charts that reference calculations in a free area, which change dynamically based on selections in a pivot table on the top of the workbook -- this way i build "normal" dynamic charts off of a pivot table without having to use a pivot chart. this normally works 100% ok.

>> 3 charts work perfectly fine but the 4th is not updating the x-values, even though the y-values update 100% ok. in other words, as i pivot on the table, the y-values change but the x values remain the same -- even though the cells they reference have changed. i tried using a named range for these cells, which did not work.

>> the chart that isn't working is a bar chart that shows category growth first and growth of individual brands below. if i remove the "category" x label from on top, the chart otherwise updates just fine. if i change the "category" x label to a blank cell or numeric value, the chart updates fine. leaving it as a text field or a cell reference to another text field is somehow causing the chart not to update when the referenced values change.

any clues??? i'm totally stuck.

jason gers
whitestone, ny

5.Duplicating Pivot Chart / Changing Pivot Chart data range

I have a worksheet with a pivot table and an associated pivot chart,
nicely formatted. I want to make a duplicate of this so I can
configure the data selection differently (this goes out to a group of
users who aren't so good at doing more than basic manipulation of the
pivot table), but still retain the
formatting and structure. In Excel 2003, I just duplicated the
worksheet and the new
pivot chart would be associated with the new pivot table.  In Excel
2007, I find the new pivot chart is *still* tied back to the original
pivot table.  Is there a way around this?

If I select the Pivot Chart Tools, I see 'Select Data', but the
for "Chart data range" is grayed out and will not allow edits.  Any
help is
greatly appreciated.

Thank you .

6. Pivot Chart only charting one series when Pivot Table shows two C# and ASP.net

7. Swap values in a stacked bar pivot chart

8. Incorrect values on pivot chart???help!!!

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 82 guest