## Hot answers tagged charts

6

It is treating the X values as categories rather than numbers. It does that with certain kinds of graphs regardless of the datatype. A bar graph is one of those. Start with an XY chart (the button is labelled "scatter" chart), which treats the X values as a continuous variable.

4

Found the answer here. If you make the formula return NA() instead of "", the chart will accept it as empty and not display a line.

2

How would you like that to look? Excel connects two data points with a line and it uses the shortest distance to do so. If you want the chart to show a horizontal line to the next day with data points, then you need to have the previous day's balance on the current day as a starting data point. See a sample data set and chart in the following screenshot.
...

2

You have two options if you don't like Excel's default assumption that you want your line chart to show "in between" dates where you have no specific data points.
Option 1 - show them as blanks
If you add the weekend dates into your data, but leave the values blank, your chart does this. This might be what you're looking for.
Option 2 - skip the dates ...

1

Here is another approach. Organize your data in a table layout so either Apples and Bananas are column headings and the data is in the columns beneath them, or they are row labels and the data extends to the right on those rows. Highlight all of the data, including the labels, and insert a Line chart (select the first style that includes markers). If the ...

1

If I understand the question correctly, you're looking for something like this when you click a data point in a scatter chart?
Robert Mundigl describes how to do this on his Clearly and Simply blog, adapting a Jon Peltier technique. It works really well.
Read the blog for the full detail. I've only summarised the key steps below.
Robert Mundigl ...

1

Ok, I found a way of convincing Excel to do this. I set the axis to be a date type, and then changed the X values to be dates relative to a particular date (I chose 1/1/2014). I multiplied my numbers by 1000 and added the result to the days since 1/1/2014 (=DATE(2014,1,E3*1000)) where E3 is the cell with my original value.

Only top voted, non community-wiki answers of a minimum length are eligible