graph

  1. M

    Copying Data and Graphs - Graph data is staying linked to the copy source rather than the paste data

    Hi All, I have a series of data that is linked dynamically to a cell in a drop down - Cell A1 is the drop down cell. The resultant data is then used to create a series of Excel Graphs. Both the data and graphs run from Row 1 thru 40. I copy this data, from column 1 thru 40, to row 41 thru 80...
  2. C

    call compare report

    Hello, I need help with building a graphical report in excel. Basically i have an employee data from 2 states(SC & MA). The employees have went through some training between March 1st to March 16th to improve their performance and I need to show difference in improvement before(Mar1st - 16th)...
  3. B

    Plotting two non linear curves and extracting an average percentage imporvement

    I have two sets of data on excel with differing X and Y values and I am looking to draw comparisons and get an average % increase in flow for pressure over the range. Basically I did two experiments and want to compare the two and somehow quantify the improvement made statistically from the...
  4. F

    How do I make the color gradient of my surface chart to match my "heat map"?

    I have this "heat" map here and this surface graph here how do i make the gradient on my surface graph to match the heat map dynamically?
  5. S

    Graph with Bars (Ranges) & Lines

    Hello, How would I go about making a graph which plots a number of bars (representing ranges) and lines on the same graph as per below: I would like the lines (which represent the 5th and 95th percentiles of the ranges) to intersect the range as shown in the image. Any ideas?
  6. D

    Charting Data

    I am trying to take data with random dates 9/5, 9/12, 9/19, 9/26 on the X axis and graph them and when I do the axis with the dates is reading all dates in between is there a way to only have the dates specified show up on the graph rather then all dates in between?
  7. C

    Dynamic Graphs, as columns are added daily

    Hello, I have searched online and in the forum for this answer. Everything I find only references is you have a table, or data within two columns, and you are adding additional rows of data. My scenario is that I have my dates as my headers/labels, and my data name/header is in column A. As...
  8. J

    Help creating a graph

    Hello I need help creating a graph, I have a photo of what I need - what is the best way to display a photo on the forum? Thanks Jay
  9. 2

    Last cell on column graph

    Hi there, just wondering if a column on a graph can be made to change as different cells are chosen. As an example, Column c, cell C2 is $400. The graph shows $400. If i take $200 from the total, Column c, cell C3 becomes $200. I would like the graph to now show the new balance from C3 instead...
  10. J

    Columns on a graph

    Hi there, just wondering if a column on a graph can be made to change as different cells are chosen. As an example, Column c, cell C2 is $400. The graph shows $400. If i take $200 from the total, Column c, cell C3 becomes $200. I would like the graph to now show the new balance from C3 instead...
  11. Skybluekid

    Multi Level Category Graph

    Hi All, Are able to produce a Multi Level Category Graph with Power BI?
  12. B

    Dynamic date range on x axis

    I am struggling to create an x axis which covers a date range that changes. The attached image shows my data, the bar graph and the date range I want to use on the x axis. https://paste.pics/70955
  13. I

    Formula Rounding

    Hello, I've got a problem with a couple formulas I've entered on a spreadsheet. The first formula is performing a calculation based on data from another tab. I want it to round the results to the nearest whole number. I can click "Decrease Decimal" and it shows 1.9 as 2 for example. The...
  14. J

    Rotate histogram graph

    Hello does anyone know how to rotate a histogram graph 90 deg Thank you
  15. J

    Histogram graph

    Hello We use a product that generates an histogram on a PDF I would like to generate a mirror image of the report but I also need help to generate an histogram graph. How can I show you how the reports looks as I can't post images
  16. J

    line graph

    Hello All I was wondering how do I change the dot size (plot points) on a line graph Mine are too big Thank you Jason
  17. C

    Bar graph with two different scalas on the Y-axis

    I have a table with two data columns: the first column contains naming values, the second column contains values from 0 to 1, the third - values from 1.000 to 100.000. I want to display them on the same (bar) graph. I've seen such graphs, where on the X axis are naming values (from column A)...
  18. M

    Chart Help

    Hello, I have a sample below of my spreadsheet for data that my customer provides. I need to create a graph (preferably line graph) to show the trend of information. We want to be able to switch/filter between the different part numbers so we can see that specific part's history. I have...
  19. M

    recording changes to a value so i can plot a graph

    Hi i'm having an issue working out how to go about recording changes to a value that's dynamic (Changes from month to month) so i can make a graph. Bit hard to explain so i'll post a screenshot. If someone could point me in the right direction happy to learn If any additional info required...
  20. P

    Graphing swimmers' times over time

    Hi, I'm trying to create a graph that compares several swimmers time at different meets. The data is stored as follows: <tbody> Date Swimmer A Swimmer B Swimmer C 1/1/2018 01:53.55 01:50.51 6/5/2018 01:34.22 01:45.12 7/9/2018 01:30.10 01:35.12 </tbody> I know times must be...

Some videos you may like

This Week's Hot Topics

Top