1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. V

    VBA Code to automatically fill dates horizontally (not to last column)

    Hello everyone! This is my very first post on but I've been a site regular for many months now. You guys rock! I always find a thread of someone having the same doubt as myself, but I now have a somewhat specific query: I have a data sheet that is updated monthly where monthly...
  6. R

    Lines on graph updates but x axis doesn't

    I have an excel file containing share prices, and graphs to show how the shar price moves each month. When I drag down the data for the date and share prices for the last 30 days, it updates the line on the graph to show the movement, but the date on the x axis doesn't change. So last month, I...
  7. E

    Moving a 3D graph from Plotly (Python) into Excel, whilst keeping its interactive features

    Using Plotly (with Python), I have generated an interactive 3D graph. Please could you help me in finding a way to plot the graph in Excel, so that it keeps its interactive features (i.e. Graph is replotted within Excel if data of the axis value is changed)? i.e. Imagine that there were four...
  8. M

    Dynamic Graph

    Is there a tool in Excel 2016 that allows you to create a dynamic graph? By that I mean you write out a few parameters at the top of a spreadsheet and the graph goes and gets the data where it needs it from elsewhere in your sheet and updates itself. My guess is this process will have to be...
  9. T

    Word Crash, paste fail and colour loss during VBA Macro when Pasting Image from Excel

    This code is driving me insane. I have created a macro that is structured as below. It creates a chart based, copies it from an Excel Chart tab and pastespecials it into word. Creates a page break, clears the clipboard and does it again for a total of around 100 times. Please see the below...
  10. P

    How to make a graph that change according to current date ?

    I would like to create a simple graph that changes according to the current date. So I have two values that are added in a "Total" cell, lets say for example : B4 = 75 and B5 = 50, so the the "Total" cell would be 125. And the graph I want would show the time evolution of this "Total" value, but...
  11. M

    Time graph per area

    Hello !! I’m trying to make a similar graph to the one attached . Is there anyway to do this ? I have a start and end time and criteria (instead of weekday I have area )
  12. L

    Userform search

    Hi, I have a table with 45 members and let's say 100 columns. Each column is a date and members will have a negative figure within the cell referencing their name and the date if they have a holiday. (EG John Smith is off on 12th June so he would be -8 in cell H22). I want to be able to...
  13. M

    Combo Chart - linking data to different data points

    I have attempted to attach the mini sheet below with a Data Input table in which I have created. All of the cells in the Standard columns have a drop down list connected to them including the following: Year 1, Year 2, Year 3 etc. The cells in the ticks column is a manual entry...
  14. J

    I need help understanding why only half of my chart table headings are appearing

    Half of my headings in my chart table are not appearing. It's only happening with certain graph tales and I can't figure out why. If anyone knows how to fix this, I would greatly appreciate it.
  15. V

    Making a Bar Graph from Unsual Data Format

    I am trying make a bar graph of the data shown below. The x-axis should be "Years" and the y-axis, should be "INCOME," "SPENDING," and "TIPS." In my attempt below, it can be seen that "TIPS" are not following the correct "Years" input. I created this graph be using the Graph Wizard in Excel...
  16. M

    Excel Graph Help Please - Plotting the Fall on a Line Graph Showing Height and Length

    Hi Folks, I'm hope you can help. I am looking to create a graph within Excel, to show pipe fall over height and length (the gradient). My data is as following: Length: 85 Height: 3.50 Gradient: 25 (1 in 25) Ideally, I want the left axis to be the height with the bottom of the graph...
  17. E

    line graph not showing on top of bar stacked bar graph

    I have a stacked bar graph. I converted one of the series to a line graph (Change Series Chart type then select line graph) but the line series is not showing. Any advise? I am using Excel 2010 so No combo graph option.
  18. E

    Tracking hires and costs

    Hi, I'm new here and was hoping you can help me deciding the best way to design a template in Excel. I need to track resources and spent by department and by project. The idea is that in this table I register every resource, when they start, when they finish, their salary and what project...
  19. J

    using relative reference in a marco to make graphs

    I am trying to use a macro to make a lot of graphs and format them from a sheet of data. I am able to make a relative reference macro work with formatting difference cells (e.g. highlighting) but when I try to make it work with a graph it still uses absolute references to make a new graph. I...
  20. J

    Display graph/chart in userform based on Combobox selections

    Hi all, So, I have a serform (U1), which has two combo boxes (CB1 and CB2). I would like the user to be able to make a selection from each combo box and this to plot a graph. The Y-axis values of both comboboxes is the same. I have a work sheet (see pic), with the number of fruit sales on...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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