line chart

  1. P

    Add 'Window' (?) To Line Chart

    I'm trying to add a window (if that's even the right term) to a line chart. I've done a mockup attached - it's just a line chart with a yellow rectangle drawn over it. Is there a way to actually add this rectangle as part of the chart and make it dynamic based on cell values? I want it to...
  2. E

    line graph not showing on top of bar stacked bar graph

    I have a stacked bar graph. I converted one of the series to a line graph (Change Series Chart type then select line graph) but the line series is not showing. Any advise? I am using Excel 2010 so No combo graph option.
  3. T

    Change axis bounds in Excel based on data

    I am creating many line graphs and would like to know of a way to change the vertical axis bound minimum and maximum based on the data itself? For example for set of data, the amounts ranges from 6 million to 12 million while another data set ranges from 3 thousand to 5 thousand. Same graph just...
  4. Z

    How to hide 0s in graph using VBA?

    I want to create a Line chart that doesn't graph 0 values. I know there are methods to change the data to be able to graph 0s but I can't do that for a variety of reasons. Is there anyway of not graphing the zeros? Or replace all the 0 values in an array of arrays that represent my data? I'd...
  5. V

    Create a line chart with flexible end columns

    Hi all thanks a lot in advance to the people that will help me with this. I have to create a line chart which should automatically updates according to the variable length of the columns of data that I want to display in my line chart. Any help/code that can help me? my line chart shows the...
  6. G

    Chart Not hiding 0 Values even after NA() formulae applied

    Hello, I've been trying to get a line chart to hide 0 values. I've tried forcing the formulae to make a blank cell and for a NA() but the chart still connects 0 values.- (Please see video link below) Any help on how to solve this would be hugely appreciated...
  7. J

    Creating multiple separate line graphs at once

    ​Hi, I have about 400 SKUs and I would like to track the demand trend using the sales figures. Is it possible generate multiple separate line graphs for each SKU? I'm aiming to get an output similar to the image below. Table 1 <tbody> ITEM_SIZE ITEM CODE (SKU) Apr May Jun Jul Aug Sept Oct...
  8. W

    Line Chart Peercentage Errors

    I have a spread sheet with percentages that I placed into a line chart; there are three separate categories (lines). However, the percentages in the cells do not match how they are plotted on the chart. It is almost line they are multiplied. I tried all the different line charts; when I use a...
  9. T

    plotting a chart, disregarding certain values.

    Hi all, I am trying to create a workbook that plots a line chart of two data sets. the problem i am running into is that some of the time-stamps from one set will not match up with the others, and thus need to be ignored. i managed to do this with if statements easily, and currently, any non...
  10. B

    Re-order Legend for VBA Created Line Chart

    Hi All, Feel like this one is easy but I can't find it... I have a task at work where I routinely plot several thousand coat weights and it's a bit tedious so I wrote a little macro to just take out the mundane nature of it. I wrote it so that I just select the 3 columns of data (always lower...
  11. C

    Excel line chart (how to change axis points)

    If I have the following data for example: <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 70px"><col width="103"><col width="80"></colgroup><tbody> Weight (lb) Type of Dog Speed (mph) 50 Dalmatian 12 60...
  12. N

    PivotChart - Stacked column and line chart issue

    I'm trying to create a PivotChart that looks like this: However, since my data is organized like below I cannot find a proper way to do that. And my chart ends up looking like this, where I have a line for each sales stage: Is there any way I can sum the the perceived sales value, so...
  13. H

    Excel 2013 - x Axis label alignment on a line chart (how to rotate labels)

    I know how to do this in Excel 2010 but I can't seem to find options for this in Excel 2013. I would like to rotate my x axis labels. In Excel 2010 there is an option where you can set the angle of an x axis label. But when I choose Format Axis in 2013 I cannot see an option for alignment...
  14. S

    Line Chart

    Hi, I have 20000+ records in a table, and I want to produce a line chart from the following columns: 1) Number: decimal values 2) Date: can have duplicates 3) ItemGroup: can have duplicates The line chart should show the evolution of the Number for each ItemGroup over time (by Date). I am...
  15. P

    Blank/NA values to be shown as dotted line rather than straight line in Charts

    Hello there, I request your help on solving this question. Say, I have values such as 1,2,3,4,5,6,7,8,9,10 plotted in Excel Chart. If I want to delete values 3,4, the missing values can be interpolated using the "Hidden and Empty Cells" option. This option connects only through a thick line...
  16. M

    Data Missing when Plotting 2 Axes with Different x-axis Values

    Hi there, I'm currently trying to plot two different data sets on the same line graph. The x-axis is time for both, however, the time is spaced at different intervals for each. (i.e. one records a point every 15 seconds, and the other records a point every 20 sec). My attempt at combining...
  17. C

    Creating plot chart

    Imgur I want to plot a line chart for the max spread over time, can anyone assist me in doing this as i'm getting confused when going to select data etc. I want it so that the time is x axis and the y is the amount of spread over time. Also so when the data updates, the chart changes with it...
  18. S

    Vertical Line in Line Chart with Text Axis

    Hello, I currently have a line chart in Excel 2010 which documents the level of total charges on specific dates. The reports that these data points are based on is not run on a regular basis, so I am using a Text Axis to capture and display only the specific dates on the X-axis, which are as...
  19. L

    VBA to change x-axis category labels to Text or Timescale

    Hi, I am extremely new with VBA and have been trying for several hours on on how to change my x-axis label which now reads "1 to 12" to a string/text /timescale "Jan to Dec". my data structure looks similar to the below Dept Jan Feb March w 20 30 20 x 40 34 54 y...
  20. D

    VBA: Create Line Chart with unknonw ending source

    I am working on a project that I need to create a Line Chart from the data that the user enter weekly. This is what I've got so far: ' Graph ActiveSheet.ChartObjects("Comparison").Activate ActiveChart.SeriesCollection.NewSeries ActiveChart.SeriesCollection(1).name = "=""Actual...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back