graph

  1. V

    Macro to add Series on Graph

    I am trying to automatically add series using VBA. I have a list of values that I want to graph and I want to see if I can automatically do it based on different values. My graph would be column K as the x-axis; column J as the y-axis and column B as my series names and pulling data from them...
  2. J

    Trying to get a compliance formula based on content of a vlookup list.

    Hi all, I am slowly getting through a spreadsheet I am trying to make to show requirements for training, date taken, then highlight when it becomes due, or overdue. This will then allow you to email a copy of the sheet, or drop a graph straight into powerpoint for you. Most of it is done now, I...
  3. T

    Access graph does not center on box

    I cannot find a way to fix an issue with Access 2016 concerning graphs in forms. When I make a graph in other versions of Access, the graph automatically centers on the box it is in. Not in 2016 though. Is there something I am overlooking? I have tried everything I know can cannot figure out...
  4. T

    Change Chart Range

    I'm trying to graph a changing amount of data, and need to coax Excel into showing only the relevant data, not blanks or zeroes. The amount of data changes on the fly (depending upon promotions, seasons, etc.) I have formulas that INDEX/MATCH the correct data, but there may be anywhere from...
  5. C

    hourly bar graph

    Need to make a (daily) hourly bar graph for my work schedule. The data part would be the name, starting time, ending time. I work like to select a horizontal bar graph view as in the image to produce this graph...
  6. C

    Bar Graph (Horizontal) for time

    I want to make a bar graph for a schedule for a work week. Column A: (format: Date) I'll put in the date Column B: (format: Name) I'll insert the Name Column C: (format: Time In) I'll insert the Time started Column D: (format: Time Out) I'll insert the Time started Column E: (formula needed for...
  7. I

    IF conditions for Graph

    Hi there! I have three columns of data ( 'Name', 'Year' and 'Marks') I want to build Year vs Marks graph, however I need it to only plot for specific names like John for example. Is it possible? =Sheet1!$C$1:$C$6844,Sheet1!$E$1:$E$6844 This is the current formula I'm using, but it does not...
  8. HomeTek

    Changing Dynamic Graph Data Based On Cell Data

    Hi all, Do you know if there is any way (without using VBA) that I can get the graph to change depending on the value entered into cell E2. A4 will always be the starting cell data for the graph, but the graph will take more days into consideration the higher the value in E2. Thanks
  9. A

    Displaying A Duration in Time on a graph with general number formatted axis

    Hi, I'm looking for some help please. I need to find a way of including a value that is being displayed as a duration (e.g. 12:32 as mm:ss) but is inserted into excel using the decimal number system (as it allows me to add different times together). Generally these values that I am working...
  10. C

    Conditional Formatting of a stacked chart that adds YTD totals

    Trying to Conditional format a Stacked graph for a YTD total. Sample data is below: <tbody> Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Target 506 476 491 495 501 489 508 503 519 487...
  11. L

    Excel graph with 2 legends

    Hi all, I want to create a graph based on years (2017, 2018 and 2019), companies (A1, A2 and A3) and type of product (cake, chocolate and cookie). I know it's possible to create a graph based on 2 of these, but it is possible to based one on all of them? If so, how should I setup my data? Thanks.
  12. K

    Excel to Outlook macro

    Hi, I'm looking for a way to connect Excel to Outlook. I have 5 identical sheets, each with one graph and an e-mailadress in cell A2. I want to build a macro that pastes the graph into an e-mail and sends it to the address included in that sheet, and then does the same for the next sheet, etc...
  13. M

    Dynamic formatting of labels in Excel.....is it possible??

    Hi, I have a range of dynamic data - I have a formula that returns the euro difference between two sets of numbers, however, I can change this to return the percentage difference between the numbers. In short the numbers in my resultant range are either € values or percentage values. I am...
  14. A

    Hide columns without values in a graph

    Hi, I have a graph like the one below: It comes from a Pivot table, and when the country is filtered with a Slicer (in this example DE), the other doesn't have values. How can I hide the column without values? Thank you
  15. N

    Office Excel 365 - Insert Map - No Southern Ireland?

    Hi All, I have a list of values and locations. I then go to insert, then map graph. A map appears and plots well, but the southern Ireland bit of the map is missing. I've tried changing it to towns, cities etc, but southern ireland is blanked out. Does anyone know why or how I could get...
  16. M

    Automatic date chart

    All, I have a sheet in which in column A contains the all the dates of 2019. In columns B and C calculations are automatically performed when data for that day is available from an external database. If no data is available (e.g. tomorrow; 21-3-2019) the cell will be left blank using an IF...
  17. A

    Graph Advice

    Fairly experienced user of Excel but not really used anything more than a basic column/line graph for using two columns of data. I now have three columns of data and i feel like, with experience, it may be possible to work out a way to show the data in a useful manner - Though i haven't got a...
  18. Q

    Graph order count per user (between start and end dates)

    Hi All, I have a series of project for several people that have start and end dates, and I wanted to create a graph to count the number of active projects over time (per day) for each owner - would have to be line graph series (each line representing each owner). ie...
  19. M

    Help with stacked graph and multiple data columns

    <tbody> CR - 2016 AB - 2016 CR - 2017 AB - 2017 CR - 2018 AB - 2018 Nov 3711 2382 6533 1344 6474 781 Dec 3218 1378 4886 484 5370 671 Jan 3702 2004 5962 790 6031 386 Feb 3840 2494 6132 601 6288 1097 </tbody> Hi All, I’m after some assistance with...
  20. T

    Create graph with data from 100 sheets - macro and loop?

    I have a data set with individual measurements of over 100 pieces - each in a single sheet. I need to create line chart with all data plotted in a single graph. The name of each sheet is in cell J1 Y-Axis range is J2:J256 X-Axis range is C2:C256 How can I create a marco which automatically plots...

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