format chart

  1. Prevost

    adjusting time based horizontal axis on stacked bar 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...
  2. E

    Formatting Graph using VBA

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

    Formatting Chart Data

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

    Formatting Transparency of Axes in VBA

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

    Conditional Formating of Bar Chart

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

    Formatting Plots Series Based On User Parameters

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

    XL2010 Heat Map Conditional Formatting within a Column Chart

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

    Pivot Chart Lock format+ other problems

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

    Is there a way to add Percent Values to a stacked column Chart?

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top