Problems with Area Graph


New Member
Sep 22, 2011
Hello there,
I am trying to plot two different data sets on an area graph. Both data sets have an x axis that include months. However, while one set of data would graph correctly (i.e correct y point for particular x point), the other data set seems to be shifting on the graph (i.e. wrong y data for that particular x point). I am not sure why this is happening. Please let me know if anyone has experienced this problem before. As an aside, graphing these data points on a line graph yield the correct picture. Perhaps this isn't possible on an area graph-- i find that hard to believe!

Gerald Higgins

Well-known Member
Mar 26, 2007
Hi, welcome to the board. Are you using a stacked area chart ? Maybe you want a simple area chart instead.


New Member
Sep 22, 2011
Hi Gerald, thanks for the response! No, I am not using the stacked area graph at all. I tried two ways to get the area graphs to plot correctly. The first is plotting using the first area graph option which should just plot data in a straight forward manner-- x for months, y for data value at time x. The second thing I tried was to plot the graph in a line graph first-- this showed up correctly--- however when I changed the graph option thereafter, it goes back to plotting all over the place. As an example, the last data point reflected on the graph is for Feb-06-- but the data source is ordered from Jan06-Apr11. On top of that, on the graph that particular Feb 06 data point is reflecting a different value than the amount for that date from my data source people.
I am at a lost. Is my excel possesed by demons?

Jon Peltier

MrExcel MVP
May 14, 2003
In an area chart, all series use the X values for the first series. This is the case with line charts as well.

You may need to insert interpolated values for each series for the dates that only the other series has data. A line chart will interpolate properly, but an area chart treats the missing in-between values as zeros.

Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...