graph

Hello everyone! This is my very first post on mrexcel.com 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...

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

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

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

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

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

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 )

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

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

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.

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

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

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.

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

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

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

Hello, I'm trying to write a VBA code to replace an old graph in PowerPoint with a new graph from Excel. I can currently export the graph to the PowerPoint file but I cannot get the positioning right. I've tried using the functions .Top, .Height, .Width etc. but this doesn't put the graph...

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

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

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