Stack Overflow
Stack Overflow

Questions tagged [excel-charts]

In Excel, you can create graphical representations of your data in your spreadsheet in charts.

Charts are visual representations of worksheet data. Charts often makes it easier to understand the data in a worksheet because users can easily pick out patterns and trends illustrated in the chart that are otherwise difficult to see.

Different types of charts serve different purposes.

Pie Charts -- are used to show percentages. For example, a pie chart could be used to show what percentage of your total daily calorie intake is represented by one quadruple cheese and bacon hamburger.

Column Charts -- are used to show comparisons between items of data. Each column in the chart represents the value of one item of data. An example of this would be to compare the calories in a quadruple cheese and bacon hamburger with the calories in a glass of water and a bowl of beet greens.

Bar Charts -- are very similar to column charts, except they run horizontally on the page instead of vertically like column charts.

Line Charts -- are used to show trends over time. Each line in the graph shows the changes in the value of one item of data. For example you could show changes in your weight over a period of months as a result of eating a quadruple cheese and bacon hamburger every day for lunch.

456 questions
2
votes
2 answers

Toggle Series within a Chart using VBA

Good Morning people, I am looking to toggle a chart series using VBA and user-form to select specific series, I've had success with a line chart. However when I try to use a bar chart, it does not seem to update the data, only the legend. The VBA…
Kristianwalker1993
  • 21
  • 3
2
votes
1 answer

Pie chart with three fields in Ms Excel

I want to make three field pie chart with label name and three colors. But i am not able to do. What I have tried : Select all fields Insert -> pie chart But this does not work at all :( This is my sample data : year test2 test3 2010 20 …
Annie
  • 2,397
  • 3
  • 18
  • 26
2
votes
2 answers

Separate data by month

I have an employer list indicating the reinforcement shifts per dd/mm/yyyy in an Excel 2003 workbook. With the next macro I get in the same document, all the GP per person multiplied by 4.83 indicating the result in a new column. Option…
kestrelol
  • 91
  • 2
  • 6
2
votes
1 answer

VBA loop updating series in chart using data from another sheet

In sheets("Cost"), there is an error commented in the code below. Once the error is resolved, I plan to put a 'c(x)' counter to loop through each chart Run-time error '1004': Method 'Range' of object '_Worksheet' failed I think the error has…
mrod
  • 49
  • 1
  • 8
2
votes
1 answer

Moving average calculation for empty points in excel

I am generating trendline for the given data points using excel trendline formula. In normal case (without empty points) moving average is working fine. But i not able to proceed with empty points for moving average trendline. I couldn't find out…
Bharathi
  • 1,288
  • 2
  • 14
  • 40
2
votes
1 answer

VBA Update source data for chart

I am using VBA to generate a chart. With the following code I can select the data from column number 11 to the last column, which I have stored in LastColumnNumber variable: ActiveChart.SetSourceData Source:=Union(Sheets(SheetName).Range(Cells(1,…
Angelin Calu
  • 1,905
  • 8
  • 24
  • 44
2
votes
1 answer

Creating a Stack Area Chart that shows Issues over Time using Beginning and End Dates

My Data looks like this: ||UNIQUE_KEY||LABEL1||LABEL2||START_DATE||END_DATE|| What I'd like to do is have 2 stacked area charts that show totals (count of UNIQUE_KEY), one chart for LABEL1 values & another for LABEL2values over time. X axis would…
US_Bennett
  • 31
  • 2
2
votes
1 answer

Creating Chart with VBA, can't format X-Axis as Text

I am working on creating a macro that generates a chart. The chart creation works as I expected, no issues there. The only problem I have is that the dates being shown in the X-Axis are incorrect. Sub generateChart() ' Select a range starting in…
BruceWayne
  • 22,923
  • 15
  • 65
  • 110
2
votes
1 answer

Generate Excel file with chart with data from mysql database using PHP

I want to generate an excel file with chart based on the data from MySQL database using PHP with PHPExcel Library. I searched a lot..but could not find a solution Values are exported to the excel file.but the chart doesnt show up. require_once…
affaz
  • 1,191
  • 9
  • 23
2
votes
1 answer

Plotting logarthmic chart - N log N in Excel

I am currently analysing and profiling Quick Sort with numerous data size. I have already collected the required data from the profiler. And I have also plotted the graph for the average run time against the data size. Now I would like to plot the…
RDM
  • 1,136
  • 3
  • 28
  • 50
2
votes
2 answers

Add data points to Excel stacked bar chart

I have a table with salary ranges for various titles and individual salaries (see below). Data: What I'd like to do, is to create a stacked bar (or column) chart in MS Excel (Office 365 ProPlus) which shows the ranges, as well as the individual…
Mad Monk
  • 23
  • 1
  • 1
  • 4
2
votes
2 answers

Excel: 100% Stack Bar Chart, the bars are not plotting correct for few combination of values

Please look at the image below: How can orange bar in the first chart be that big. This pattern repeats even if I make both values half like 105, 21 or 53, 10 etc. As soon as value is value is 43 the chart starts behaving fine. Thanks.
Kashif
  • 14,071
  • 18
  • 66
  • 98
2
votes
0 answers

Excel templates can't be applied

On Excel 2013, when trying to change the chart type of a pivot chart to a template saved to the template folder I get the following error message: This template can't be applied. It's either damaged or won't work for the selected chart. Please try…
Maximilian Kohl
  • 632
  • 1
  • 9
  • 23
2
votes
2 answers

Get equation for 3d shape

I have 2 arrays say X and Y. Each have 5 elements. Now for each possible combination of (X,Y) I have a Z value, so Z is a 5x5 matrix. I am looking to find a formula e.g. z=f(x,y). Any idea about how that can be done. I tried MS Excel surface…
Amit Sharma
  • 131
  • 1
  • 2
  • 12
2
votes
1 answer

How to make a zoomable chart in excel 2013

I have 4000 columns and 200 rows in an excel spreadsheet, I want to make a line chart with all data in it, but once I created the chart, it is too hard to see each individual item in the chart even if I zoom the page to max. Is there any better…
Root Loop
  • 3,004
  • 9
  • 46
  • 72
1 2
3
…
30 31