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?

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...