format chart

Hi There. I have 19760 date & time values in column A (it starts in June and each row is incremented by 1 minute). Columns B, C, D, and E have energy uses for each minute for different pieces of equipment. I want to create a stacked bar chart showing the total energy used for each minute but in...

Hi there, I was wondering if anyone can help me. I want to format a chart when a particular cell is chosen. This cell may be in another sheet, but I don't want the sheet to change to where the chart is. I just want the chart to update in the background. Is this possible? Here is my code that...

Hi all, I know this question has been asked over and over again, but no matter how much I search I dont seem to able to find a suitable resolution. My challenge would seem to be simple, but I am unable to sort it out by myself. I work in a call centre and I record my daily figures. My target is...

I'm sure this isn't news here, but Excel 2007's Record Macro function doesn't play nice with formatting charts. What I need to do is adjust the transparency for my (xlCategory, xlSecondary) and (xlValue, xlPrimary) axes. I've tried many different options for <!--?--><!--?-->"?" within...

I have my information in I have the Gantt chart set up the last bit of the puzzle is coloring the chart. I am need to have it this way: (using excel 2010) If the bar below is smaller than the bar above then color. If the bar below is greater than the bar above then color.

Hi all, I have been googling my issue for hours, and I can't find any solutions online, so I though I'd ask the experts. I am trying to format about 15 plots with several data series each, so I want to write a macro to automate the process rather than formatting 100+ series by hand. I have...

Hi "First time caller, long time listener" I've searched for a thread like this - indeed I found one so I added to the end of it, but got no replies - so here goes: I have the following data: <TABLE style="WIDTH: 96pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0...

I have a pivot chart that is 'live' ie we will use the graphs (stacked bar or bar) to analysie the data, then when there is a problem send this out to the department. (data is monthly usage from equipment) Problem being that when we change cost centers etc etc the colours for the data...

Is there a way to add the % values that each section of a stacked column represents that is easier than individual text boxes?