line chart

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. H

    Line Chart Series Vertical Line

    Hi All I have a line chart that displays a comission scheme for a salesperson. The commission paid (Y axis) depends on the sales generated (X axis). Let's assume $100 = $0 payment $200 = $0 payment $300 = $50 payment $400 = $100 payment At $299 of sales, nothing is paid. The line should...
  20. A

    Line Chart not plotting Percentages correctly

    <TBODY> Plan</SPAN> POC</SPAN> Setup</SPAN> Reaff</SPAN> Jan</SPAN> 50.00%</SPAN> 10.00%</SPAN> 15.00%</SPAN> 10.00%</SPAN> Feb</SPAN> 40.00%</SPAN> 20.00%</SPAN> 20.00%</SPAN> 20.00%</SPAN> Mar</SPAN> 30.00%</SPAN> 30.00%</SPAN> 25.00%</SPAN> 30.00%</SPAN> Apr</SPAN>...

Some videos you may like

This Week's Hot Topics

Top