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.

368 questions
-1
votes
1 answer

How can I add labels onto the pie pieces that are large enough to contain them, and alongside those that aren't?

I've got simple bogus data that generates this Excel Chart: This is the code: object misValue = System.Reflection.Missing.Value; //add data _xlSheet.Cells[11, 11] = ""; _xlSheet.Cells[11, 12] = "Student1"; _xlSheet.Cells[11, 13] =…
B. Clay Shannon
  • 1,055
  • 124
  • 399
  • 759
-1
votes
1 answer

Creating upper and lower bound slopes to a linear equation statistically

The following graph represents my dataset, it is change in strain (y axis) and change in temperature (x axis) As you can see it is a linear relationship, I am wanting to create upper and lower bound thresholds in a robust statistical manner. Below…
-2
votes
1 answer

VBA Macro code to copy multiple charts from Excel to Words and save them in different docs

I do have an Excel file with multiple tabs in it. Each tab is tagged with a different referenced number and i would like to copy a chart contained in each WrkSht and paste it in different Word files, saving each word File with the tab name. Thanks! …
FGp
  • 1
  • 1
-2
votes
1 answer

Creating Multiple Candlestick charts from a csv file

I am trying to create multiple candlestick charts for given date ranges which I have a list of in Excel. I have OHLC daily price data and need to use this data to create roughly 1100 charts. I would like these charts to be in a printable format…
Ed Lee
  • 3
  • 2
-2
votes
2 answers

Excel chart for displaying Yes or No values against list of features and companies

I have the following chart in excel. It has listed the features and companies who are supporting the features. Hence, It has Yes or No values in it. I want to display nicely in excel chart. I tried using PivotTable report, but it didn't accept this…
Stella
  • 1,657
  • 3
  • 34
  • 83
-2
votes
1 answer

Bar chart or histogram of grouped values

For a table as above how can I count how many labels have value between [0-2] and [3-5] and with Excel show that as a bar chart or histogram?
Amir-Mousavi
  • 3,249
  • 4
  • 40
  • 86
-3
votes
1 answer

Create a pie chart in excel for pass and fail values

I have done some manual testing for the website where I have 3 different test results on Desktop, Tablet and Mobile for a single test case. Now I want to represent all of my test results into a Pie Chart where it will show the total number of Pass,…
Paramveer
  • 15
  • 4
-3
votes
1 answer

Calling a chart from different sheet

I have 12 charts in sheet 'A' in excel. In sheet 'B' there are 2 drop downs and based on that value I want to call a particular chart in sheet 'B'. How do I do that? Can i write a vba program for each chart? Pls help
1 2 3
24
25