graphs

Hi.. Im hoping someone can help me with some help building a graph. I have a spreadsheet which I have simplified down to two columns, one is date, and the other is a number between 1 and 10. The number between 1-10 signifies a category of a particular event that happened that day. Some dates...

I have a basic graph like this: Right now I have data labels showing each point on the gray line, and on the orange line. I would like to have the difference between the two (i.e. the Up/Down Bars) labeled. I've Googled this problem and have not found an easy way to do this. Any help? I found...

Hi, I have a pivot table and I need a code which will create graph using that Pivot table. Graph should be in same worksheet ans should get linked to the Pivot table. Any idea how it can be done? Pivot table looks smthn like that. <tbody> Category Jan Feb Total A 15 2 17 B 20...

Hi, This may be easy or it may be difficult, but I can't figure out how to do it!! I have a number of cities and a number of departure times and I wanted to show: On the bottom axis, I want to show the times from 08:00-22:00 On the side Axis, I want to show the cities (or a number for a city...

Hello everyone, kindly help, i have two sheets in a workbook, in one i have data which updates on daily basis and a new row adds and in other sheet i have graph which needs to update for last 30 days(1st case) / just the new added row (2nd ) case. below mention code can do it if the graph is...

Hi I need to create a graph in Excel, but the data have start and end dates. I've got more than 300 000 lines with data like that. Do you know how I can create a bar/line chart for daily/monthly MW maintenance with data like below (time on x-axis and MW on y-axis)...

Hello, i have a question about graphs in VBA. In my worksheet, Column A has the dates and columns B to F have different series of dates. I have created a formula that locates a data range. For example, the user needs to see the data from 1 jan to 1 feb only, so the formula finds this info from...

Hi, sorry if this has been asked before (I did a quick search, but I'm not exactly sure how to phrase it!). I have some data for a company, lets say Jim's garage, this consists of a number of products, for ease, product 1, product 2 and product 3. I have quartile data for each product (Lower...

Hi, I need help with a formula to select only a range in between dates that the user can chose from. for example, i have a huge data base (from the year 2000 to 2015) and i wish to see a graph only from the year 2014. I need a formula to identify the range between the dates and select only this...

Hello all, This is my first post and I have been racking my brain trying to find an answer to this question. I hope you can all help. We have created a excel spreadsheet that pulls from other tabs in order to give a snap shot of an employees pay grade range and a compa ratio. In order to...

Hi everyone, I hope you can see the below image. What I would like to do is be able to insert a line graph for FY2013, FY2014, FY2015 on a graph. Preferably in a pivot graph since I need to filter under "dealer" to get the results from a database I have created. I can do this manually, but if...

Hello, I'm creating some reports at work, and all the graphs I'm creating are taking up too much room on each sheet. I'm wondering if it's possible to make each graph the same size and lay them on top of each other, and use tabs to flick between them (similar to the tabs at the bottom of the...

Hello, I have a spreadsheet where I input values and then these values are graphed into a 3rd degree polynomial. The equation of the polynomial is displayed on the graph. I'd like to make it to where the values of the constants are transcribed into separate cells. I've put the spreadsheet...

Hi, I'm creating a bar graph comparing month by month data (by percent) for 2015. Of course I only have data for January and February so far but I'm making this for other people and can't change it later. I've added the rest of the fields so they'll populate once data becomes available...

Alright, so imagine there are y values - speed: 10, 0, 10, 10 and corresponding x values - time in seconds: 0, 20, 40, 50 Now, how can I show that at the 11th second it suddenly stops, then after 2 seconds continues with the speed of 40? So I want the line to go vertically downward. I tried...

Hi guys, I'm working on a project where I have to analyse reviews, gain feedback reviews and produce charts. Let me show you some example data... <colgroup><col width="64" span="26" style="width:48pt"> </colgroup><tbody> reviews Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13...

Hi, I have a graph with x and y values. I have more than 10,000 points. For an easy example, Say x y 1 2 2 6 3 7 4 9 5 11 I like to have a graph with x and y values but eliminate one coordinate. For example, for one condition, I like to remove the coordinate (3, 7). The graph should...

Hi guys, I have two similar excel workbooks, one [Model.xls] serves as a model for another [Target.xls], so that the cell references for the ranges are the same in both spreadsheets. Model.xls contains charts/graphs that I want to move to Target.xls. I want these objects to reference the same...

I am trying to create a macro to a graph which shows a year worth of data, however when another quarter of the year is added (13 Weeks), i want the graph to be updated by moving on every quarter for 12 months from the last piece of data. For instance, i have data between the 7th April - 30th...

I have a chart that shows the total number of moves per day in bar chart form. The chart also utilizes a scatterplot as a second axis to show the number of hours utilized in that day as well. My goal is to keep my chart as is, with a bar chart and then the scatter plot markers, but to also...