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
3
votes
3 answers

Remove series from chart with VBA

I am creating a chart in excel via vba code. I am using contiguous data and the chart pops up no problem, however there is an extra series named "Series 3" that I didn't ask for and need to get rid of (via deleting it or omitting in the first…
M Kaye
  • 153
  • 2
  • 6
  • 14
3
votes
1 answer

Highcharts: having trouble recreating stacked area chart from Excel with positive and negative values

I'm converting a series of Excel charts into Highcharts, and came across a curious situation involving a stacked area chart with both positive and negative values. Here is now the chart is displayed in Excel, along with the accompanying data points.…
3
votes
0 answers

How to copy a chart to different sheet using Apache POI(3.11)

I need to copy/move the chart to different existing/new sheet. Can we do this using POI? I am able to move the chart within the same sheet but not to different sheets.
Babu
  • 165
  • 3
  • 12
3
votes
1 answer

Structured references in charts disappear, why?

I click on a chart, click on "select data" and then click on "edit data series". This popup appears: I want to change this cell reference to a proper table reference. So I write a table reference into the data series: Now I click on enter and…
user1283776
  • 19,640
  • 49
  • 136
  • 276
2
votes
2 answers

Arrange charts position in 3x5 order

I have the following problem. Thank you in advance for the help - I am trying to arrange 7 charts[Doughnut] in a 3x4 fashion i.e., I want 3 columns and 4 rows of the charts. Below is what my code is printing in excel worksheet. I want it printed in…
Jrules80
  • 178
  • 12
2
votes
1 answer

Excel Chart not updating correctly with VBA

So I have made a macro to export a chart and then import it into a userform as picture. Import/export is working fince, byt the chart is not updating when the data changes and looks differently every time I open the workbook. When I delete the data…
cbm9000
  • 47
  • 5
2
votes
2 answers

How do i create excel chart with SXSSFSheet using apache POI?

My project is using SXSSFWorkbook in order to generate excel files as the excel files generated in the application can be of large size as well. Now I need to include excel charts in these excel files as well and i am not able to create charts with…
Amit Pokhrel
  • 282
  • 4
  • 21
2
votes
1 answer

Merge two array in one to fill column stacked chart

What is the best way to merge those both array : Array1 Red Orange Red Red Orange Array2 3 7 9 15 32 The output excepted is : Orange Red 7 3 32 9 0 15 The Idea is to use this output array to do…
TourEiffel
  • 4,034
  • 2
  • 16
  • 45
2
votes
0 answers

Excel is plotting my date x-axis completely, and I cannot work out why

I have a very simple Excel data set which plots 15-minute date/time segments against values. When I try to plot it as a line graph in Excel (mac), Excel inexplicably renders the results wrongly. It seems to plot only one value for each day, and I…
Mike I
  • 21
  • 2
2
votes
2 answers

Dynamically add series to a chart

I'm trying to create an excel which, using a couple of data validation toggle lists and a button, allows a user to display a specific plot for a specific stage of a model build. To do this, I need to be able to add series dynamically to a chart. I…
dougl
  • 23
  • 3
2
votes
2 answers

Copy Excel chart to the end of a Word document

I'm trying to copy text and charts from Excel to Word. The problem is that the chart is always appearing on top of the Word document. How can I add the chart at the end of the Word document? Here is my code: Sub Test() Dim tbl As Excel.Range Dim…
2
votes
2 answers

ERROR when trying to make a chart in Excel Macro

I am trying to make a macro that will make a chart for me out of two columns of data. I keep coming across this error no matter what I do. I've attached an image here.
2
votes
1 answer

Openpyxl - Creating a chart on a different sheet

I have been using Openpyxl to transfer pandas dataframes to an Excel file. I have to work utilising a template file given to me by work. Because I cannot modify much in the 'printable' sheets, I created a worksheet at the end of the workbook where I…
Luis Landa
  • 21
  • 1
  • 2
2
votes
1 answer

What is the relationship between ShapeRange, Chart, ChartArea, & PlotArea

Ok, so a ChartObject has a Chart & ShapeRange member. And a Chart has a ChartArea and PlotArea member: What exactly is the Chart member? It say's it "represents" the chart - what does that mean? Is the ShapeRange a range the ChartObject holds? And…
David Thielen
  • 28,723
  • 34
  • 119
  • 193
2
votes
1 answer

How can I vary the marker colors in an Excel graph?

I have an Excel line graph with markers. I need to change the color of the marker if it is below a threshold. For example, the graph below is monthly results where the markers are above a threshold. If the results are below a certain point, I need…
H.Cani
  • 31
  • 1
1
2
3
30 31