chart 2010

Hi, I have difficulties in created a stacked column chart with year and age group in x-axis in excel 2010. I would like to seek your advice on how to make a stacked column chart showing no of people of 2 different age group, e.g. below 60, and 60 or above in different year (2010, 2011...

I have four categories across multiple series of data. Let's call them Red, Blue, Green, Yellow. I have a stacked chart showing the numbers of data points in each category. The chart has labels showing the value of each point, centred in each colour. However, sometimes there is none of a...

I have seen a lot of similar questions but nothing that is quite the same as what I am trying to do. I am trying to modify Data Labels in a chart tab, which was copied from another chart. I already have a macro that changes the data and the chart title but now I want to change data labels of...

Hi, I have been facing this excel chart issue recently and have spent a bit of time browsing various other forums to no avail. Hoping by putting it up in a post, I might be able to learn if anyone else has come across something similar or would happen to know a solution. I am currently using...

Good day people. Thank you for your support so far... I need to merge some data values from some spreadsheets to another.. Table A for Year 2013 <tbody> Family ID City State Postal Code Amount </tbody> Table B for Year 2014 <tbody> Family ID City State Postal Code Amount...

Hello everyone, I am trying to insert text boxes onto my chart based on the bar chart coordinates. I am not sure if this is doable. I am trying to loop through the series and select and based on that selection I need to find upper left and right corner coordinates of that bar chart so that I...

Programing a procedure which opens a .ppt template and copies in charts and tables from Excel for multiple generation of presentations (a Do Loop) for a new .ppt per record on a specific worksheet. What appears to be an every-other-time/record event, the pasting of an Excel chart is interrupted...

Hello, I have a vertical bar chart that I'm looking to center on the X-axis. Essentially, I want there to be gaps between the bars and the Y axis, and from the last bar to the end of the X-axis, but I'd like the bars to abut each other. Can someone tell me the best way to do this? Thanks! Mike

I have charted a couple of spirals on a worksheet and now want to connect the the corresponding points between each spiral with a line. There are 700 points in each spiral, not something I want to set up manually. Can I write a macro that selects the chart, reads a pair of coordinates from...

Hello this is my first time post so please bear with me if i did not clearly stated my problem. My question is regarding charting in excel where i have main category(SW rel) and sub category(Problem type seen in given sw release) that could have 3 different features where problem can be seen...

Hi guys! I was hoping someone could help me. I need to create a Clustered-Stacked Column Chart with Target Line From a pivot table now, it seems easy (I just recorded the macro, here it is): ActiveSheet.Shapes.AddChart.Select ActiveChart.ChartType = xlColumnStacked...

Hello, In Excel 2010 I have columns of data representing 13 period in a year (P1 - P13). These columns repeat every year and I have several years of data - so a lot of columns! Each period a number of faults is recorded in the corresponding cell. I have a chart that shows the data from the...

Hello all, This is my first post and I have been racking my brain trying to find an answer to this question. I hope you can all help. We have created a excel spreadsheet that pulls from other tabs in order to give a snap shot of an employees pay grade range and a compa ratio. In order to...

HI I am working on huge amount of Data and I need to create charts for more than 277 sheets each with over 10000 rows and 92 Columns. The Data are measurmnets for some force over the year and these measurments are recorded in a table for 365 days and for each day there are 24 records a...

What would be the best way to display the chart's name on the chart so that, when selecting a chart for printing, users can identify the correct one?

Hello, I have a chart with three variables plotted on a chart with two y-axis. Two variables are tied to the primary y axis, and the third is linked to the secondary y-axis. When the chart is displayed, the third, secondary axis variable shows up in between the two other variables. Is there...

Hi, I've been searching through forums and trying (in vain) many ways to create a chart (Using Excel 2010) that displays a Project name on one axis, a project milestone on the other axis and the month as the 'value'. This may be asking Excel to do too much but basically I have a series of...

Can anybody suggest efficient way to record vacation dates for dozen employees from three small departments and would this work as a line chart? Using 2010. Any suggestions, however brief, appreciated. :confused:

Hi, Could anyone teach me how to select multiple columns in CurrentRegion property so that I can create a Bar chart based on it Below are my progress so far.. however it doesn't work Public Function FourthTable() Dim Source As Workbook Dim Search As Range Dim CR As Range...

Hi all, I have created a combination chart in excel - my bar chart covers 3 years and I'd like to show the growth rate as a line chart on top of those. Is there a way to limit the line chart to just the outer two years? When I alter the data selection to only include the growth rate for 2 of...