graph

  1. O

    Graph to view comparison of monthly changes to numbers

    Hi, I have data tracking the change in account volume from one month to the next for 2 different companies. I'm looking for the best chart to use to visualise this data. Company Name Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23 Jan-24 Feb-24 Mar-24 Apr-24 May-24 Company 1 -454 -1,058...
  2. F

    Exponential Colour Filling for Graph

    Good morning, I'm working on a graph which gives ratings to processes, from 1 to 5, based on two variables. The total Score is a multiplication of both variables. For example: -Process 1: (Variable A: 2, Variable B: 4, Aggregate score: 8) -Process 2: (Variable A: 3, Variable B: 3, Aggregate...
  3. B

    Right align numbers in Bar Graph data table chart in excel?

    how can I right align numbers in data table chart of graph, I'm not finding any option on excel
  4. mohsinbipu

    Wagon wheel graph in Excel

    Dear Excel expert, Can you please kindly help me to find out a way to draw a graph like this
  5. Q

    Graphing multiple concurrent events over time

    I am trying to graph attendance over time for a large number of events. This data is presented by week, so I have attendance per week for each event. The events take place in multiple locations, so I want to be able to see how attendance compares at each venue by graphing the lines on top of...
  6. B

    Graph/chart options for 5 years of monthly data points for 40 departments

    Hi all, I am trying to figure out how to best visualize 5 years of monthly data of sales figures across 40 departments, where the goal is to find trends in a given month-year combination for a department (and perhaps ideally, comparing across the 40 departments for the 5 years of month-year...
  7. V

    39 sponges in a tray...

    Hello and thank you in advance if you're reading this. I think it will be fairly easy to solve but my Excel knowledge is limited. I work at a production company that can fit 39 "sponges" into one shipping box. Because a production run total changes based on the amount of material we have, the...
  8. L

    How to create a detailed performance overview (Maybe a graph/chart)

    Hello everyone, I am currently trying to create a detailed overview of transactions executed by a range of different users in the hopes of creating a easy to understand overview of performance. Which will include the points listed below. In this performance overview I want to include several...
  9. V

    Chart series date misalignment depending on source data

    Hello, I'm having an issue trying to bring multiple data sources with date X-axis values into the same chart with a VBa macro. The chart "scales" to the first series added or whichever is set as the source data. When the other series' are added, I think they might be unwittingly "discretized"...
  10. M

    Column Graph Question

    I have a manual column graph under a line graph. I'd like each column to be green until in gets above my goal, then I want it red. Is this possible. Or would it be better to do this in a VBA? See example below
  11. A

    Graph to show project progress since start date

    I've looked high and low and cannot seem to find the answer to this. I am looking to show registration progress since the start date of the project. Basically, we rolled out a new program and have had difficulty getting some of the people to register for it. I would like to show a combo graph...
  12. B

    OFFSET formula to create a dynamic chart based on 2 distinct ranges

    Hello, I am trying to create a dynamic chart with the OFFSET function to display 2 data ranges of a factory production planning. Below is an image of the planning sheet, where the first row indicates the date, the second row shows the forecast, and row 13 indicates the processed workload. Based...
  13. Jyggalag

    Color the area inbetween two lines in a chart/graph?

    Hi all, I currently have this graph here: I would like to color the area inbetween the yellow and the red line with an orange color. I would like to know: 1) is this possible, and if so, how? 2) if it is possible, is it also possible to make it do this coloring without pasting the orange...
  14. M

    How do I create this graph in Excel?

    Hello, I'd like my graph to look exactly like the graph I pictured below. I'm trying to create an area graph to shade each range percentage listed below a different color. Rage A - shade anything above 15% Range B - shade 5 - 15% Range C - shade -10 - 5% Range D - shade anything below -10%...
  15. C

    How to correctly automate Radar Chart creation process in VBA?

    Hi everybody! So I'm a total noob and have never used VBA before but I'm trying to automate the creation of 'radar charts' for work. I have a table that looks like this: And I'm trying to automate the process of creating radar charts that look like this: So far I've written this: Sub...
  16. R

    Dynamic name range missing from graphs after making copy of a worksheet

    Hi Everyone, I would be glad if you can help me regarding this please. I have an Excel sheet in which I have a graph which uses dynamic name range. The dynamic name range is, Trial=INDEX(Sheet1!$C:$C,MATCH(Sheet1!$G$3,Sheet1!$B:$B,0)):INDEX(Sheet1!$C:$C,MATCH(Sheet1!$G$4,Sheet1!$B:$B,0))...
  17. D

    dynamic charts

    I would like to make a dynamic graph that based on operator, can display various metrics related to production to a date range. The caveat here is that the graph will need to change x axis values per operator due to the fact that each operator works different days. For instance, I want to...
  18. U

    Excel bar chart

    Hi All, USing below as an example, im attempting to create a bar chart with only 2 bars but using all of the below data. So on the left hand side (y axis) will be the months, and the x-axis along the bottom will be the value scale going up in whatever say 1000s. The thing is I want 2 bars...
  19. A

    Dynamic Legend on Excel Graph

    Hi, Can anyone tell me if there is a way I can remove data AND legend (ie unfilter) a set of data that is in a chart, where the values in one set are all zeros. In this table, I would NOT want to have Sales shown on the graph and legend when all values are zero. If any of the values in Sales...
  20. Z

    Excel Novice: Need Help with Graphs

    Hello. I am trying to create a line graph that shows the change in pressure, rpm, and flow rate over time. I've been trying to use the graph tool that Excel has, but I am not getting what I want. Any help or suggestions would be appreciated. I have attached a snippet of the info I am trying to...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top