charts in excel

  1. J

    VBA Clear Chart Dynamically and refresh with new values

    Hello, I have a chart named "VelChart". It fetches data from a set of dynamically created cell values. However, I want the chart to be cleared of any graph every time I said referenced cell values are refreshed. I have this code that isn't working: Worksheets("Velocity...
  2. R

    Need to update chart while macro is running

    I have a workbook that produces a PowerPoint slide deck with statistics for 4 different products for 150 cities. Well, it's supposed to produce the slide deck. My problem is the charts are not updating as the macro runs. The 150 city names is cycled through using a macro to update a the city...
  3. I

    Automatic Series Labeling?

    Hello, Any help with the following would be much appreciated! I currently have a table with which I would like to crate a stacked area chart (see reference image). I would like the y-axis to be the raw data (values between 0-1 you see below), and I would like the x=axis to be the years you...
  4. B

    Choose source for data in excel chart

    How do I choose the source for labels and data for a chart in excel? What I want the chart to show is the label on the left to show Item name, then a line to track the sales month over month and the month and the bottom label to show the corresponding month. Also, if possible add another...
  5. I

    Excel Charts: Shifting starting point of chart based on criteria

    Hi, I have the following information: X Axis: Product (Tomato, Apple, Orange, etc) Y Axis: Date range (Sept 1-Sept 30, Oct 1-Oct 31, etc) Values: $ made on each product I want to create a simple chart that will update information based on a drop down menu selected on another sheet. For this...
  6. S

    Copy/Paste Multiple Bubble Charts from Excel to PPT

    Hi, I have an excel workbook with many different tabs and in each tab there are many different bubble charts and each bubble chart covers many cells not just one. I need a macro that will copy/paste all the charts into PowerPoint. Please help! Thank you!
  7. L

    Problems with Bell Chart

    Ok, I'm tasked with creating a chart that represents a Projection in future sales via a Bell Curve. (Honestly, I have no idea why he wants it this way... but Boss says jump, I say how high). I followed the example given on How to create a bell curve chart template in Excel? So my Data column...
  8. N

    Power Pivot to Dashboard problem

    At the moment I am having a huge problem trying to figure something out and I feel it is going to be either a PowerPivot and slice job but can’t figure out how to get the chart to show on the results in the dashboard. I have a load of data that has come from different cities and venues in...
  9. A

    Change Chart Type via VBA

    Hi All I have a few charts in a workbook, which I export to Word. One Manager likes these charts as a line chart and another Manager likes these as column charts. I've recorded two macros to change to a line chart and change to a column chart. Regarding the 1st macro (changing to line chart)...
  10. A

    Line Chart not plotting Percentages correctly

    <TBODY> Plan</SPAN> POC</SPAN> Setup</SPAN> Reaff</SPAN> Jan</SPAN> 50.00%</SPAN> 10.00%</SPAN> 15.00%</SPAN> 10.00%</SPAN> Feb</SPAN> 40.00%</SPAN> 20.00%</SPAN> 20.00%</SPAN> 20.00%</SPAN> Mar</SPAN> 30.00%</SPAN> 30.00%</SPAN> 25.00%</SPAN> 30.00%</SPAN> Apr</SPAN>...
  11. P

    How to get this type of area chart?

    I need to get a chart that shows split by 2 level of categories Sorry, don't know how to formulate it in words, so I wite it by an example for instance, that would be sales of sweets - they would be divided 1) by type of sweets (Candies, Chocolate, Ice-cream, others) 2) and by weight...
  12. T

    Copying a chart in 2010

    I have multiple tabs in the same format. If I create a chart in one tab, how can I copy it to multiple tabs with the chart source data using the destination. When I copy the chart, when I get to the new tab, it still links to the first one. As I have over 100 tabs, is there an easy way to do this?
  13. M

    Charting Analysis

    Hi charting friends I am trying to create a dynamic chart(s) that will allow me to select a percentage of total sales, either in a cell or something 60%, 70%, 80%, 90% or intermediate values that will produce a stacked bar chart. So below I have a pivot table product and sales are from the...
  14. T

    Doughtnut Chart

    Hi, I have to create a staff development chart in the form of a doughtnut/dartboard. There will be 4 levels / 4 series. The data can be based on either a 1-4 scale or increments of 25% up to 100% (obviously). What i need it to look like is the attached so that if there is a blank, the slices...
  15. F

    generate a graph with variables length of data in VBA

    I'm curently working in a workbook where data from other sheets are copied onto, after having recieved all the data (wich are of variable legth) the macro adds a Time column, previously left blak, and then generates a chart. I ran the code in several pieces and using the method above I end up...
  16. E

    Dynamic Charts - Named Range

    Hi, I want to make my charts dynamic and can only find explanations of how to do it using data from the chart in column format. i.e. the data goes down from A1:B4. My data goes across the rows. i.e. from A1:D2 How to use defined names to automatically update a chart range in Excel Microsoft...
  17. G

    Mass Chart Format Update

    I have a spreadsheet with 85 charts that I would like to update. When I created the charts, I copied and renamed the first chart to create the other 84 charts. Then, different data and titles were selected. Today, I spent 6 hours individually changing each chart to reflect a new background...
  18. D

    help creating a chart

    Im not sure its possible but can someone help me if they can?!? below are the grade boundries for a GCSE subject and I want to create a 1 column chart for pupils to show how far they are away from acheiving certain grades! I want to create something that has the grades an numbers across the...
  19. R

    Create multiple charts at once

    I have some historical stock data in many sheets in a workbook. Each stock has its own sheet, but formating/placement of data is identical across all sheets. Is there a way to create a chart in one sheet and have it duplicated across all sheets using the same ranges of data, just within its...
  20. G

    Named Ranges changing unexpectedly

    I have defined three names that refer to 10 cells in different columns of a worksheet. For example Xn_Rev is defined as =Revenue!$F$27:$F$36 On another worksheet, I have created charts to display the values, and in the charts I refer to these names. I am finding that the names change...

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
Back
Top