graphs

Hi! I am collating some feedback which I need to present in line graphs which include the data table showing the FY and the no. of response. As such, I must use the "name" column as the series name when creating these graphs. In addition, I have been using a VBA that I found online to label...

Hello, At work I created a template to filter specific data (From an excel data pull) and compile it in to graphs and tables. This has saved my department 100's of man hours, as the data pull is enormous and was sorted and reported manually before I arrived on the scene :cool: This template I...

I have few hundred data (product ID) and I have graphs for each of the data. I saved these graphs as png in a designated folder. The filename for the graph is "productID1 - productID2" because I wish to compare the data for 2 products. I wish to use VBA code to popup the image when I click on...

Hello, I have a huge excel document of quarterly business reports. Each company having 4 rows of data i want to present in a graph. Quarterly reports. https://imgur.com/a/TjQYn Graphs from data. https://imgur.com/a/QLCro The data for the next company is always 9 rows below. Right now i have...

Hi, I have a problem with a set of data and graphs my colleague has provided me to work with. The arrangement is a spreadsheet of data which links to an intermediate "working spreadsheet" which is then linked to two graphs. These final graphs is what I need to work with. They are simple bar...

Good please, could you tell me if it is possible to merge or overlay two pie charts. i need to compare performance of three departments. chart one is the base. dept a = 60 dept b = 60 dept c = 60 chart 2 show performance. dept a = 20 dept b = 50 dept c = 40 i am not looking to see...

Good morning I have a spreadsheet with a number of tabs on it I recently changed the formula set up on one of the tabs so that when the main tab containing activities was filtered, the graphs would then reflect the filtered data. Im sure there are other ways i could set it up so the graphs...

I just need a very simple explanation. On this worksheet, I'm only presented with graphs and I have to come up with the two equation by myself. How would you solve for the equation?

Hi, I am trying to create a macro to create a graph on some data from the spreadsheet. To do this I have recorded the macro of the graph I am trying to create being raised manually. The table I am trying to show data from is quite obscure and I am having to edit the graph plotting points...

Hello, I have data consisted of 18 columns. From these 18 columns I need to produce 9 graphs. However, i dont need to use entire columns for those,only last non empty cells. For instance, i need to take a value from last nonempty cell from a column A and B and use those two points to construct...

Hello! I have data consisted of 18 columns. From these 18 columns I need to produce 9 graphs. However, i dont need to use entire columns for those,only last non empty cells. For instance, i need to take a value from last nonempty cell from a column A and B and use those two points to construct...

Hi good people!, I have googled and found some codes, but they do not work. Why off course, I cannot know. I am looking for vba code which will align 4 graphs, next to each other, horizontally. The first graph must be used as "anchor"..so the remaining 3 graphs must just shift to the left or...

So yes, I have a spreadsheet on which there is a command button that launches a large userform (takes up the entire screen). On this userform is a dozen or so labels populated with numbers. I have it set up that when you click on a label a graph appears showing a trend. I'd like the ability...

So I have a sheet with multiple pie chart graphs on it with a vba code that pulls out of an SQL database. What I am running into and I feel like an actual bug in Microsoft excel. My VBA code changes the color of the pie charts based on a few different variables and the code is set to cycle every...

Hello I have this piece of code that works quite well, it changes the color of the bars based on the values. I now will have many graphs in the same sheet that I want to apply this to. How do I change it so its looking at not just 'mainchart', but instead does it to all the graphs ? Dim...

So I currently have a piece of code that only functions on one of the sheets in my workbook. I want to modify it so it can work on any of the sheets. The macro is essentially using relative ranges to graph the data. I have tried solving it myself but can't seem to get it to work. I also run...

Hello everybody, I'm trying to recreate this graphical representation for my data, which is an aggregation that consists of many series each with three columns: min, max, and average in the range from 1.0 to 4.0. I've experimented with floating bar charts, where I've created a fourth column...

Hi All, I am relatively new to excel and the world of VBA! one of my current roles is to take a years worth of data and turn it into graphs representing the 4 quarters of the year. At the moment this means I have to go in and select the data range from the master sheet for each of the 4 graphs...

I am hoping I can get some help with this issue on here. :confused: I have researched, but to no avail. I have created a dashboard using PivotTables/PivotCharts to show trends in payroll. The Dashboard has 8 different graphs on it that are controlled with 4 different slicers. When the...

<tbody style="margin: 0px; padding: 0px; border: 0px;"> up vodown votefavorite Hello! I have some data on a table("FSTHR_tests") in the worksheet ("Project Results") and want to extract some of the data to make some graphs, which will be diplayed in UserForm1. Below is my attempt to the code...