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. Leicester City Fox

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

    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

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...