pivot charts

I have a lot of graphs connected to specific Pivot charts. The Pivot Charts are refreshing when I enter in new data but the graphs connected to them will not refresh when I hit the refresh all button. I go to the graph and click the "Analyze" tab and everything is grayed out and will not let me...

I have a table with 2 columns of data. Column A has a broad description ( body, electric, plumbing, etc). Column B has a more complete description within each broad description ( 12( if next to body means crack)(if next to electric means something else), 39(if next to body means no weld). I...

Hi there, I'm fairly new to recording macro's. I've attempted to create one to consolidate some data, then create a pivot table from this, and lastly, create a graph from the pivot table. The macro appears to work fine all the way through, until it comes to the Source Data for the Graph. I've...

Probably a dumb question - but is it possible to put headers and footer in a pivot chart? I know this is possible to do in a regular chart but not having luck trying to do this in a pivot chart. Thanks

Hello, I am looking for a little bit of help with a Pivot Chart and haven't quite found what I need through various searches. Of course, I may just not be quite hitting the right terms. I would like to set up something to where a user can click on an individual value on a pivot chart...

Hi, I created a pivot chart like so: https://www.dropbox.com/s/7blnq1s7c4uv1di/pie.png The nationality legend was smaller than this but i streched it more so it can show all the legends, the only problem is that now the legend overlaps the chart and I cant seem to resize or move the chart...

I have a set of data for our company's sales representatives in each country, the amount of data is huge and I'm trying to find a way to represent in a pivot chart (or table) the list of countries that have female representatives but no male representatives.. So I've made a pivot table with the...

Hello guys, I am working on Excel 2013, I have sample table data that shows populations based on cities, the columns in the table are continent,country,city, population. what i want is : initially show continents and populations(sum by countries in the continent)), when i drill down by...

Hello guys, I am working on Excel 2013, I have sample table data that shows populations based on cities, the columns in the table are continent,country,city, population. what i want is : initially show continents and populations(sum by countries in the continent)), when i drill down by...

Hi, i'm trying to build a pivot chart to compare the labour charged vs labour recomended at different models and locations. But at the moment, the pivot chart adds the values of both workshops and models. Any ideas? I have a similar table like this: <tbody> Location Car Service Labour...

I have built my pivot table that has months across the top and the various categories on the left. When I go to create a pivot chart, it is automatically creating the categories on the left x axis and my values in each of the cells as my Y axis. I want the months to be my X and my categories...

I have a field that is in date format in PowerPivot, but when I use it in a chart, I am not able to format it. It does not matter what I do. I have tried setting it to date using the chart format functionality or changing the formatting using a custom format and nothing works. The date displays...

I have one question which is bother me for quite some time. Is It possible to make this kind of a chart with pivot chart where the blue columns are the total sales received in one hour interval for example between 13:00 and 14:00 and so on, and then the red line to show me how the orders ware...

Hello all, I was wondering if there's a way to "make" the pivot charts plot the line for the grand total column as well... not just the "inner" columns. Suggestions would be highly appreciated. Thanks!

Hello All, I have a hyper-linking or possibly a Data Validation question. I have Sheet 1, with a bunch of customer on it(Each customer has their own row). It also has some financial data on it as well, but not important. I also have Sheet 3, which is a Pivot Chart of all the customers on...

I have several pivot charts and chart worksheets in my workbook. Additionally, I have several parameters setup where the data series will change based on the criteria selected. How do I create a macro, where no matter what the criteria is set that the color format for each specific data...

I found a wonderful resource @ http://www.rondebruin.nl for macros. I have been doing trail and error. This is a very frustrating experience. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> What I am attempting to email two pivot charts in the same email...

How can I get my Pivot chart to see 0 as Blank/nul/empty cell? My initial sheet has a lookup formula in it and under certain situations the lookup will return an empty cell (or it should). My overlaying pivot table interprets this as a 0 (I'm guessing this is because the PT is looking at a...

I have created bar graphs from pivot tables and inserted them as separate worksheets (in excel 2003). I want to change the size of the plot area and move the legend. When I hide PivotChart field buttons and click on plot area the double sided arrow appears when I mouse over the black boxes on...

Hi, What I need is seems like it should be easy but I can't figure it out so I'm hoping someone with more knowledge can. I have 10 workbooks, 1 of each employee. Each workbook has one sheet for each month of the year. the table for each month is really simple; just date is the 1st column and...