graphs

Hi, I was wondering if it is possible to put thresholds on cluster graphs? currently I have five individuals who do running sessions. I know what each individuals maximum is and there minimum distance should be for a weeks work. currently I am using a pivot tables to show me the amount they run...

Hi all, This is my first time posting so not sure how this goes. Basically, I am creating an athlete monitoring database and need to give individual players specific thresholds. I have graphs showing player load during a week, and on the graph i would like to put these individual threshold on...

Hi, I work in marketing and am struggling with being able to do a pivot table due to the large number of fields and different titles. However l know what l want my end point to be. I have streams of data like the below and am basically wanting to be able to set thresholds to form the...

I would like to know of the "Open Cases", can we build something to show an age profile similar to something like "1-3 Days", "4-7 Days" "8-11 Days" etc. For this I would like to be able to see by Group, which can be looked up in the table from the "Created By" (Column I) name. The "Created...

I have a number of graph files in excel. Each graph is made up of four cells, header, graph pic and legends for X and Y. What I need is for the four of them to be merged into one item. Typically I do Printscreen, dump into Paint and cut it out from there. Is it possible to automate this with VBA...

Hi there, I have a league table with 4 weekly scores and a total column which shows the total points earned. Each player has a line graph assigned to them that shows their weekly points over the 4 weeks. The issue i am having is that each week when new points are added, the data is sorted by...

It's weird. In one tab of my workbook, any formulas resulting in 0's I have programmed to actually return a #N/A, so that when graphed, the graph looks cleaner, and the trendline is true. But in another new tab I'm working in, the #N/A results show up as zeroes on the graphs. Any reason you know...

Greetings everyone. I'm running a series of forms, combining several information for my company, among them a system that generates graphs for monthly deliveries. Since the userform does not support graphs, the alternative I found was for the macro to save them as .gif files which are loaded by...

Hi, I want to create graph but my data is dynamic. There is a product id cell and according to selected product number of data change.For example: I have 20 months sales data for one product, 30 months for other. How can I select this kind of range ? Thanks

Hi team, I'm hoping you can help. I currently operate a sales Excel workbook that my company use to record and monitor all international sales for the business. It holds all sold and forecasted information and I pivot the data to some very easy to reference tables. One of the pivot tables...

Looking for the correct syntax to change the horizontal axis type from the default "Automatic" to "Text". I have a chart that points to data on various sheets within an excel workbook. The data is pulled however, the X Axis column that it points to is in a data format. The data format is...

Hello all, I have a very large workbook that is broken down into results and data per floor. I would like to reference the data tab to pull into the results tab. There are 8 graphs that I need to populate from the data. It is on a weekly basis and the data cell I need is very fifth. Example...

i am working with a large amount of data which have to be filtered and then displayed as a pivot table and individual 2D graphs. the problem i am facing is with the pivot table because each time i loop i am creating the pivot table with the same name which throws error.Also i am unable to filter...

Dear all, I have a report with one dynamic chart (=one object for VBA) in a sheet called "VIVA GRAPH". In the picture down below you will see on the left hand side two cells that are referring to the pivot table where the slicers are linked to. There are in total 2 (countries) x 9 (models) = 18...

On occasion, my percentages in my graphs(saved perfectly as percentages) will open as decimals for someone else? I have unlinked all sources attached and cannot figure out why this happens? Any input is appreciated.

Hi, Is there a way of making the formatting of a graph so that the start and End bar are always the same colour format? I think this is probably VBA but a VBA trick but no sure? The reason i need to do this is I am using dynamic waterfall chart (using a stacked graph) where the X axis changes...

I have created a dashboard that has several graphs incorporated. I would like to add one slicer that I can connect to all of the graphs. I have gone into connections in the past and added the different graphs but with this current dashboards I haven't added the pivot tables to the data model so...

Hi there, I am looking advice on plotting a graph that shows product sales for each product over time; <colgroup><col style="width:48pt" span="3" width="64"> </colgroup><tbody> Code 23rd Nov 30th Nov K011 3 3 K012 3 6 K013 108 100...

I have about 100 sets of data, each set has 12 rows and 10 columns. I have build a graph for the first set of data. I need to duplicate that graph for the other 99 sets of data, but do not want to manually build each graph. How do I copy the graph and paste it into a new location, with new...

I'm hoping this is a simple problem to fix, thanks in advance for looking. I have a report that details lost time incidents by date. The report goes back 3 years. I have used grouping on the date column to seperate out years and months. the pivot table shows this perfectly. I then need to...