pivot chart

  1. L

    Displaying the data from 2 pivot tables in a graph

    Hi I have 2 pivot tables in Excel 2007, the data from which I need to display on a single graph. 1 pivot table contains data of how many requests for something there were in each year, and the other pivot table contains data of how many requests were responded to in each year. The catch is that...
  2. kc.crow

    How to display pivot item if it doesn't exist

    Hello Sorry for the cryptic title. Hopefully I can explain it. I have 5 possible rating values in a column. This column will be the row header for my pivot table. Say the values are 1 through 5. If the dataset I pull doesn't have a full representation of all possible values (say, it only has...
  3. P

    Label at the end of Stacked Bar Pivot Chart

    I have a stacked bar pivot chart. I would like to add a label or textbox at the end of each of the bar. How do I find and reference the x-y coordinates for the end each bar? My VBA is limited, but growing. Any snippet or code example would be great. Thanks.
  4. M

    Pivot Table/Chart Conundrum

    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...
  5. G

    Pivot Chart Lock format+ other problems

    I have a pivot chart that is 'live' ie we will use the graphs (stacked bar or bar) to analysie the data, then when there is a problem send this out to the department. (data is monthly usage from equipment) Problem being that when we change cost centers etc etc the colours for the data...
  6. C

    Chart question

    I created a pivot chart in Excel 2007 and all was fine. Then when I copied the chart sheet and data sheet to another workbook, the chart displayed all nulls as zeros and the line chart looked awful. I discovered that the data for the chart series changed from a RANGE to an ARRAY, and that was...
  7. The_Rock

    Charts from Pivot Table

    Hi Folks Is it possible to get a number of charts from 1 pivot table. For example, the results of my pivot table are: Country Year Sales Ireland 2007 5000 Ireland 2008 10000 Ireland 2009 15000 United Kindom 2007 20000 United...
  8. B

    Customize Date Filter in Pivot Table

    Hello - I am trying to customize the date filter function on a pivot table to show the last 90 days (or last 3 months would be even better). I attempted to put a formula, "=now()-90" into the date filter dialogue box, but excel won't allow it. Is there a way to do this? I would ultimately...
  9. D

    Pivot Chart - Multiple Page View - limit choices of 2nd view

    I'm trying to create a Pivot Chart (have created actually) that has two page views: 1) District and 2) Customer Name. I want a user to be able to choose their district and only the applicable customers related to their district show up in the list. Right now, all customers across all districts...
  10. A

    Pivot charts in Excel

    I provide pivot charts in Excel 2000, but some of my users are viewing them in Excel 2007. The pivot chart displays as normal but does not show the page fields. Does anyone know how I can make the pivot fields visible in Excel 2007
  11. G

    Web based pivot tables and charts

    Effective data analysis is more important then ever before, and the trend is that everything is moving online, SaaS systems and cloud computing. What we at Flexmonster did - we created a fully functional web based flex pivot table component that can be integrated into any system for effective...
  12. L

    somewhat tricky pivot table problem

    hi everyone, I have a tricky problem...well it is for me :) I currently have a large quantity of data that is in the format below: Category Detail January February March ........ Fruit Apple 10 12 16 Fruit Banana 42...
  13. D

    Graphs

    Hi, its been a long time since i've created any graphs in excel, and I'm having some difficulty is setting a particular graph up, the axis are wrong. the (table / graph) is based on the following creteria to the left (flow rate l/s) the sequence as to be as follows 0.3, 0.5 0.7, 1.0...
  14. M

    roster reports for individual people using pivots?

    Hi there. I have the following arrangement (although it's much larger with 30 categories across and a day for every year downwards): <TABLE style="WIDTH: 202pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=269><COLGROUP><COL style="WIDTH: 58pt; mso-width-source...
  15. K

    VBA thinks my range is a pivot table and can't create a chart... :(

    Hello everyone, I have a beautiful Macro that creates pivot tables in an Excel sheet for a report I am creating. I want to summarize these pivot tables with a graph and have for that reason programmed a formula that will take values in these pivot tables and add them together. I then create...
  16. A

    Pivot Table/chart

    Morning people, 3 times a week i am required to compile a report in Excel, not a problem this part i can do. Then on a seperate tab i create a pivot chart which shows all the data within the report condensed by just giving totals. Now comes the tricky part. The report shows how many of our...
  17. E

    Inputting daily stats, need output of weekly stats

    I'm tracking 4 variables daily, and need to be able to output them in various graphs (nominal, percentage of total, etc) in a weekly format that, if at all possible, can be changed in a pivot table/chart. I feel like I've done something similar before, but cannot figure how to do it again...
  18. S

    Moving Average in Pivot Table Calculating off Percentages

    Moving Average in Pivot Table Calculating off Percentages- <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> Need it to Calculate off Actuals (Need to Use a Range)<o:p></o:p> <o:p> </o:p> I have a pivot table that filters by three data fields: Card...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top