bar chart

Hi, I have a bar chart with 9 labels and i want to assign colors for each label. But every time i do that, it changes to the default colors assigned by excel in that particular order. I tried creating a custom theme but you can choose to only upto 6 colors. I clicked on the format series tab...

This might be a workaround for my problem in getting the last value in a bar chart to toggle between being displayed and not displayed. The bars on the x-axis represent the 4 previous quarterly averages, a 12 month average, and a summary average that is manually entered on the same datasheet...

I have a set of data -- emails sent per month for various users. So for example, in Nov-11 user "Bob" sent 3 emails. In Dec-14 "Bob" sent 25, "Susie" sent 15, "Michael" sent 5, and "Barbara" sent 10. I would like to have a chart that shows this, with the months being on the x-axis. I would...

Hello, I'm creating Winner-Loser charts in VBA using a bar chart with the invert function. Positive bars are to be green, and negative bars red. Below is my portion of the code that is successful in inverting the negative bars to be the left side of the vertical axis while positive bars remain...

I have a simple bar chart in excel 2010. Sorry I can't post a picture of the chart at the moment. The data included in my chart comes from the below table : <tbody> Supplied Data Levels Forename Surname D.O.B House Num Postcode Valid Phone Number Benchmark 0% 100% 0% 100% 100%...

Hi, I want to amalgamate a scatter chart and a bar chart. I have the following data <tbody> 09:00 09:15 10:00 10:35 11:00 London 5 4 Total 10 20 15 Sold 8 17 13 </tbody> So basically, I want to see the following two graphs amalgamated...pictures attached... (View image: Total...

Hello! Ive encountered a problem i have no idea how to solve. Ill write whole story: We had a practical assignment with water pumps. We took the power consumed by pumps like 240W for example and measured the height of hose 1-7 meters. So the power consumption changes when the hose gets higher...

Hi there, I've been struggling to combine these two different types of graphs together - I have made the stacked bar graph and a line graph and would love to just somehow overlay the bar graph with the line graph. From the research I've done I've seen recommendations to add the data relating...

I received a request to color code the bars in a bar chart a different color based on different criteria. Any thoughts on how to approach this request? Thanx ...... Rick

I received a request to programatically color code a bar in a chart based on different threshold criteria. Bars for values meeting one criteria would be one color, those meeting another would be a different color. Any thoughts on how to approach this? Thanx ...... Rick

I have a graph of weights over 5 years and the weight range is 180-200, but the graph shows 0-220. How can I get it to just show the range area where there is data (180-200)?

Hi, I am trying to make a bar graph using a primary and secondary axis and want my bars to appear side by side (un-stacked) but no matter what Chart Type I select the graph keeps stacking my bars Can anyone help find a solution? Thanks!

I am trying to get a chart to display pivoted peer values within a single column. I want the column to represent the spectrum of percentages, with a highlighted section for values over a certain threshold level. I'd also like to include a percentile rank, if this is possible. Is there any way to...

I have peer values that I want to rank in a single column to benchmark them against each other. I would also like these to include percentile ranks of the overall peer group, but I want the chart to include only values over a certain level. For example, these are some of the values I want to...

Hi everyone. I'm trying to produce a clustered and stacked (or stacked and clustered depending on your phrasing) bar chart. The rows in my data can have multiple values spanning across multiple columns, but not all row/column intersections will have values (and at certain times, rows will have...

I would like to create a chart that looks like this: http://img406.imageshack.us/img406/6536/visualizationchallenge.gif How do I do it?

Hello everyone! Alright, I'm going to explain my situation in length so that its clear what I wish to accomplish. One quick point: If Excel 2013 can make graphs that skip nominally blank cells (they'll have a formula that returns an error value or 0), then the rest of my post is moot. I've...

Hello, Attached is my spreadsheet (SHIFT_COMPARE) which is supposed to plot the work hours that employees are scheduled to work vs the day they are working, on a weekly basis. It consists of 3 worksheets: "Const", "Sched", & "Chart". "Const" = a "back end" sheet containing constants & raw...

Just moved onto Excel 2010 and having some difficulty working out how to resize the width of the bars/space between bars in a bar chart. Pretty basic but I cannot work it out!

Hello! I'm in a bit of a pickle. I normally can answer most of the Excel questions that come my way, but I'm not sure of how I can do this. Using Excel 2010, I have a pivot table that is pulling information from a raw data set. Some of the pivot table does not have a value, and shows a gap in...