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
1
vote
4 answers

Avoid Excel Chart streching line till end after series flattens

I have a table of total 12 columns and 30 rows. The table looks like below. Note that real data are very different than this, but follows this pattern - the value goes upto some number and keeps repeating for all rows. Data I want to plot a line…
shyamsantoki
  • 115
  • 1
  • 9
1
vote
1 answer

Calling a macro when selecting a chart sheet

I'm using the following simple code to run a macro "mymacro" when clicking/selecting a sheet. Private Sub Worksheet_Activate() Call mymacro End sub When i execute the macro manually it's working very well but when i click on the sheet it is…
a.lay
  • 161
  • 2
  • 8
1
vote
1 answer

Defining X and Y axis min and max values

I have a simple VBA code, which changes the minimum and maximum values of my chart according to values given in certain cells. The code looks like this: Sub X_Axis_Values() Dim Cht As Chart Set Cht = ActiveSheet.ChartObjects("Chart…
Kolumbo
  • 51
  • 5
1
vote
0 answers

Error 800004005 when trying to adjust chart axis range in vba

I am trying to adjust my chart axis with a VBA function however i keep running into error 800004005. When i google the error i can find a page that refers to the sheet security but there is no sheet security set in my workbook. I am using the…
user4373888
  • 53
  • 1
  • 12
1
vote
1 answer

Deleting title from all graphs and charts

I wrote a very simple code to delete all titles from graphs. It works sometimes, but some other times nothing happens. Sub changeformatting() For Each Sht In Application.Worksheets For Each cht In Sht.ChartObjects cht.Height =…
Gabi
  • 15
  • 3
1
vote
1 answer

How to add a vertical line on an existing chart?

I tried to apply what I have found online, but I wasn't able to apply it on my code. The axis x give me some issue, I can't choose the existing point on axis x on my chart (see line highlighted). The way I do it create a new x-axis with 2 values. '…
JLuc01
  • 187
  • 1
  • 12
1
vote
1 answer

rename charts in a boolean vba

how are you? Can someone help me? I have the following code that generates graphics: Sheets("kips").Select Dim i As Integer 'rows Dim j As Integer 'columns i = Cells(Rows.Count, 1).End(xlUp).Row For j = 2 To 5 With…
1
vote
1 answer

Remove just 0 values from Chart Excel

I have been trying to remove these 0 from the Excel Chart i have watched multiple videos used Format Control #,##0;-#,##0;;. and different things available on Google but nothing is happening. I have replace the 0 value with Nothing#. Go to advance…
user15169505
1
vote
1 answer

select chart VBA

I keep getting run time error 424 when running my VBA code. this line of my code gets highlighted. ActiveChart.Axes(xlValue, xlPrimary).AxisTitle.Text = "Angular Rate (deg/s)" This is my second chart on the excel so I think VBA is struggling to…
Mazen
  • 3
  • 3
1
vote
1 answer

Excel Chart title will not accept a date concatonated to a string

I'm trying to include a date in my excel chart title by putting a formula inside the title formula box: ="Some text "&TEXT(NOW(),"mmm dd") I've tried putting the date into a cell, and referencing the cell, but that doesn't work: ="Some text…
DrWhat
  • 2,360
  • 5
  • 19
  • 33
1
vote
0 answers

Paste Group of Charts as Pictures

I want to send a daily distribution of charts in an Excel workbook. In my master file, the chart ranges are updated each day. I am sending the charts as pictures to help with easier viewing. I distribute the charts in 2 columns, hence the modulus…
PDubs
  • 7
  • 3
1
vote
1 answer

How can I use Excel to scatterplot more than 255 X-Y pairs from .csv file?

My XY data is converted to a category axis when I attempt to scatterplot more than 303 pairs; bogus data generated IN Excel (such as going to cell B3 and entering B2+1, then dragging that formula down to 1,000 rows, doing same in column C) will…
R. Wolford
  • 11
  • 1
1
vote
0 answers

Format.Line.ForeColor.RGB Overrides MarkerForegroundColor

Excel VBA Line Color / Marker Line Color showed the difference between Format.Line.ForeColor.RGB and MarkerForegroundColor, and I found that Format.Line.ForeColor.RGB influences MarkerForegroundColor. Sub color_border() With…
Junyong Kim
  • 279
  • 1
  • 2
  • 10
1
vote
1 answer

Chart type related problems when setting up chart type xlDoughnut

I have written a macro to populate a doughnut chart dynamically. I need the data labels outside of the doughnut. The only way I was able to achieve this was by assigning the data to a chart of type xlPie and running another macro. Setting…
Friedrich
  • 118
  • 1
  • 1
  • 12
1
vote
1 answer

Change color of a chart series as the same as another series but with different line style

I am trying to make a code for changing colour of one series to match another series but with different linestyle (eg. dashed). Please see the code that I have made. I get error messages. Thank you Sub lineeditor() Dim j As Integer Dim wsheet As…