1. N

    Use VBA to modify Chart series data

    Hi, I have an excel model that I have built that displays YTD data on a weekly basis in the form of graphs. There are a 7 of different tabs, 5 are for each individual site, 1 is a combined tab, 1 is for comparisons and the final one displays retail data. My question is whether or not it is...
  2. J

    Upgraded to 2016: Graphs are no longer animated running VBA

    Hello, I did some searching but could not find anything that seemed to work for me so I apologize if this has been asked before: Our office recently did a batch of Windows upgrades and I'm now on Excel 2016. I have numerous macros that will perform iterations and update numbers on the screen...
  3. S

    Graphs not updating when data changes

    I have a workbook that looksup values and does reports and has some graphs in it. The graphs used to automatically update when I change the record number of each file. Now it doesn't. It only works if I chnage the record then save the file then re-open it. Help please!! :confused:
  4. S

    Disappearing graphs

    I have a workbook where whenever I click save the graphs disappear but when i close and open the file again they are there again. I have read up on it and there are workarounds but I would like a permanent fix. Anyone know a way around this...
  5. L

    Help with Downloading and finding images that work in Power Bi

    Reference :Help in Easily Downloading new images into Power Bi for chartinfo graphs or find images that can be easily downloading to use in Power Bi Hi there I a new to Power Bi ... so be gentle with me :) I have download images in my picture but when I downloadthem into power bi when I...
  6. P

    VBA Import Data from Standardized Format to Current Workbook

    Hi all, So basically I am trying to create a standardized tool that I can give to customers, and it will return graphs and values for a number of metrics. I want the sheet to have a button that says something along the lines of "Add data here" and they can add their data from another workbook...
  7. J

    Graphs! Graphs! Graphs?

    Hi all, I have recently been dropped with this on my desktop & told "make it into a graph" no amount of "I have no idea" doesn't compute with the hierarchy. Long shot but can anyone help or point me in the right direction? History for the below is as described, the below data represents...
  8. D

    56 graphs on one sheet

    Hey everyone I have a spreadsheet with 56 graphs on one sheet. Is there a macro that will cut and paste each chart and place on a separate worksheet? A bonus would be if the worksheet can reflect the chart title (department/unit name)
  9. E

    VBA: putting a series of graphs from Excel into PowerPoint

    I created a spreadsheet with a drop-down that changed the data on display in the graph for the selection. I've been asked to create a powerpoint pack that shows each of these graphs on a different slide. There are 35 options in the drop-down. There are actually two graphs for each option...
  10. N

    Dynamic minimum/maximum value x-axis graph

    Hi all, So, I've two fields with week numbers. One consisting of the week number in which an activity starts (StartWeekNumber) and one with the end week numbers (FinishWeekNumbers). I'm constructing a graph with on the x-axis as a minimum the StartWeekNumber and as a maximum the...
  11. R

    New at Graphs, etc

    Hi everyone, first time poster but read the forums often and have learned a lot. I dont use the graphs, etc in Excel very often I am trying to find the best way to display this info in a graph (the boss is persistent that it be graphed. I have put in a bar chart, but now they are asking if it...
  12. R

    More Horizontal Axis Labels

    Hello All, I hope you can help me. I have a graph, and I have dates as the axis labels (horizontal axis) - I am struggling to find a way to add more axis labels (more dates) along the horizontal axis. Do you have any advice on how to do this? Do you have any further tips to format the graph I...
  13. P

    Power BI App online version

    Hi all, Just trying to get my head into this fantastic program and have hit a brick wall and wondered if someone could be so kind in pointing me in the right directiong. I have pulled some data from a excel sheet (as i can get it to work from a access database) and have built some tables and...
  14. B

    Producing graphs representing segments from different sample sizes

    Hi there, I'm producing some graphs based on a set of questionnaires. Some are Likert Scale statements and some are simple yes/no/don't know questions. We are trying to split the answers down by type of respondents: Amenity manager; productive managers; multi-functional managers; and...
  15. O

    Two Bar Graphs with Two Different Y Axes

    How can I graph two lines of data into bars that share the same x axis, but different Y axes and are not stacked. The alternate is to make one of them a line graph, but in the case I need them both as independent bar graphs next to each other and referencing different y axes. Thanks in advance...
  16. C

    Changing Excel Graph Series based on Tab Title

    I'm working on a spreadsheet that will chart data monthly. I want to give each month it's own tab. I've set up a tab (Current Month) that shows data on - you guessed it! - the current month's data, using the Today() function in A1 for the sheet to determine the current month. I created all my...
  17. C

    Color matched/linked

    If I want to have the same color following a for example a "brand" in a graph. Excel automatic set colours depending on the value, but if I for ex in my graphs always want that AUDI to displayed in RED and BMW displayed as BLUE. What function must I use ?
  18. W

    Sales Dashboard / Speedometer Radials

    Are there any sale dashboard templates people use that they could share? Particularly interested in Speedometer Radial type graphs. I.e green is good, yellow ok and red is bad.
  19. I

    Excel Charts: Shifting starting point of chart based on criteria

    Hi, I have the following information: X Axis: Product (Tomato, Apple, Orange, etc) Y Axis: Date range (Sept 1-Sept 30, Oct 1-Oct 31, etc) Values: $ made on each product I want to create a simple chart that will update information based on a drop down menu selected on another sheet. For this...
  20. S

    Prevent Graph linking to old workbook after copying

    Hello All, I am running a macro that grabs data(array of data and a graph of this data) from a workbook and enters into another workbook. However the graph keeps the old series links (this data is changed daily so changes the graphs in new wokbooks) is there an easy way to make it so the seris...

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