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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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