graph

how can I right align numbers in data table chart of graph, I'm not finding any option on excel

Dear Excel expert, Can you please kindly help me to find out a way to draw a graph like this

I am trying to graph attendance over time for a large number of events. This data is presented by week, so I have attendance per week for each event. The events take place in multiple locations, so I want to be able to see how attendance compares at each venue by graphing the lines on top of...

Hi all, I am trying to figure out how to best visualize 5 years of monthly data of sales figures across 40 departments, where the goal is to find trends in a given month-year combination for a department (and perhaps ideally, comparing across the 40 departments for the 5 years of month-year...

Hello and thank you in advance if you're reading this. I think it will be fairly easy to solve but my Excel knowledge is limited. I work at a production company that can fit 39 "sponges" into one shipping box. Because a production run total changes based on the amount of material we have, the...

Hello everyone, I am currently trying to create a detailed overview of transactions executed by a range of different users in the hopes of creating a easy to understand overview of performance. Which will include the points listed below. In this performance overview I want to include several...

Hello, I'm having an issue trying to bring multiple data sources with date X-axis values into the same chart with a VBa macro. The chart "scales" to the first series added or whichever is set as the source data. When the other series' are added, I think they might be unwittingly "discretized"...

I have a manual column graph under a line graph. I'd like each column to be green until in gets above my goal, then I want it red. Is this possible. Or would it be better to do this in a VBA? See example below

I've looked high and low and cannot seem to find the answer to this. I am looking to show registration progress since the start date of the project. Basically, we rolled out a new program and have had difficulty getting some of the people to register for it. I would like to show a combo graph...

Hello, I am trying to create a dynamic chart with the OFFSET function to display 2 data ranges of a factory production planning. Below is an image of the planning sheet, where the first row indicates the date, the second row shows the forecast, and row 13 indicates the processed workload. Based...

Hi all, I currently have this graph here: I would like to color the area inbetween the yellow and the red line with an orange color. I would like to know: 1) is this possible, and if so, how? 2) if it is possible, is it also possible to make it do this coloring without pasting the orange...

Hello, I'd like my graph to look exactly like the graph I pictured below. I'm trying to create an area graph to shade each range percentage listed below a different color. Rage A - shade anything above 15% Range B - shade 5 - 15% Range C - shade -10 - 5% Range D - shade anything below -10%...

Hi everybody! So I'm a total noob and have never used VBA before but I'm trying to automate the creation of 'radar charts' for work. I have a table that looks like this: And I'm trying to automate the process of creating radar charts that look like this: So far I've written this: Sub...

Hi Everyone, I would be glad if you can help me regarding this please. I have an Excel sheet in which I have a graph which uses dynamic name range. The dynamic name range is, Trial=INDEX(Sheet1!$C:$C,MATCH(Sheet1!$G$3,Sheet1!$B:$B,0)):INDEX(Sheet1!$C:$C,MATCH(Sheet1!$G$4,Sheet1!$B:$B,0))...

I would like to make a dynamic graph that based on operator, can display various metrics related to production to a date range. The caveat here is that the graph will need to change x axis values per operator due to the fact that each operator works different days. For instance, I want to...

Hi All, USing below as an example, im attempting to create a bar chart with only 2 bars but using all of the below data. So on the left hand side (y axis) will be the months, and the x-axis along the bottom will be the value scale going up in whatever say 1000s. The thing is I want 2 bars...

Hi, Can anyone tell me if there is a way I can remove data AND legend (ie unfilter) a set of data that is in a chart, where the values in one set are all zeros. In this table, I would NOT want to have Sales shown on the graph and legend when all values are zero. If any of the values in Sales...

Hello. I am trying to create a line graph that shows the change in pressure, rpm, and flow rate over time. I've been trying to use the graph tool that Excel has, but I am not getting what I want. Any help or suggestions would be appreciated. I have attached a snippet of the info I am trying to...

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