bar chart

Wondering if anyone can help, not being familiar this is probably an easy one for someone with Excel ninja skills: Along the x axis = time; y axis = ticket cluster ID Each ticket cluster ID has a life span (date range) which is shown in x-axis and within each ticket cluster ID is a number of...

Does anyone know how to create a formula that will fill a shape with a specific color is a specific event happens? For my issue, I have created a Bar Chart to serve as a Gantt Chart to keep track of timeline events. Right now, each bar represents an event in time, and they end and begin one...

Hi, I have the chart below that I am very happy with except for one thing: . I would like each column to be in two colors or shades using the type of order (EDI or FAX) to determine how much of the column is one color/shade and how much is the other color/shade. I don't know how to add...

How can I stop trend line at August, I have September forcast bar in chart, actuals trend line goes upto August and then fall to zero in September because there are no actuals for September yet. How can I avoid trend line to go to September. Thanks

I have a question on drawing bar graphs. I have calculated CAPEX and OPEX prices with a max point and a min point. Now I want Excel to produce a graph that shows the min point as the minimum and than a bar up to the max point with a point for normal CAPEX/OPEX. Is this possible?

My data is daily, however I want my bar chart to show weekly instead of daily.

I have a few small bar charts containing data from a survey such as Yes/No/Maybe questions. They are listed in that order (first Yes, then No and Maybe is the last option). When I use this data to make a bar chart, the data on the vertical axis is ordered the other way, Maybe on top, then No...

Hi all, Just a quick query about drawing a graph. I would like to draw a movement graph, let's say from 8am in the morning to 8pm in the evening, everyday. The x-axis would be the position. let's say you move from step 4 to step 200 within 12 hours. The y-axis would be each individual...

I have created a macro for copying a bar chart from one sheet to another. I need to be able to resize the chart on the second sheet so that takes up more cells than it did on the other sheet. Is this possible using VBA? Thanks

Hi all, I tried the search function but couldn't find anything on this. Is it possible to auto-format the datapoints in a bar chart so the colour reflects the value? Eg, all bars with a value of 90 or over display in blue? I know I can do it manually, but the chart is ongoing so it fluctuates...

Hi, I am looking to create a graph with bars coming off a line graph and I was wondering about how to go about it. I want the bars to start at the point on the line graph and move up or down to the value given. For example Say my values on the line graph are 25, 15, 17, 28 and 30...

Hi, I am fairly new to Excel and would like to create an inverted or mirrored stacked bar chart. I have 5 people and I want to show their beginning sales opportunity for 4 different products at the beginning of our quarter and want to show how much they sold at the end of the quarter. A sample...

I have a bar chart pivot table in excel where the actual names of each bar are a bit hard to understand (but still necessary to display). I only display around 10-15 bars on the plot so I have a decent amount of real estate to play with. To make the data more easily understandable, when I...

Hi there I am trying to do a bar chart that shows data by day of week. I'd like to days of the week to be in a specific order..howver Excel is putting it in a random order or I can only sort by the values by day. Is there a way to fix it so If I want it to be sunday, monday etc...it stays...

I have been googling this to no avail: How can I put multiple histograms on a single chart without having all of the bins (i.e., the x-axis values) being the same? This is easy to do with the XY Scatter Plot format (I mean letting all of the plots have their own range of X values), but I can't...

Hi: I have the code below almost finished (there are 2 macros the first one , Macro4, does the charting perfectly in sheet1) and the second macro, Macro 5, makes the macro 4 repeat itself in each sheet of my workbook except for the first sheet. However when I attempted to run the macro 5 I...

Hi, Can someone help me with the following. I need a macro to create a bar chart: the data to be charted is in one row (let's row 2); however the number of columns varies between 1 and 10. I want to a flexible macro that counts the number of columns with data, and then used that number to...

I created a bar chart for student test scores. The chart has the names of the students on the X axis and the score of each student on the Y axis. The problem I am having is that Excel can not fit all the student names on the X axis (only 30 names show up). I tried to decrease the font size of...