charts in excel

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

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

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

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

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

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!

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

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

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

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

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

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?

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

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

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

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

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

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

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

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