## Hot answers tagged charts

3

Quick and dirty -
You can spread out your data a bit as shown below. When you insert a stacked column chart, and set the gap width of the column series to 0%, you get a chart like that shown below.
Longer answer -
I wrote a tutorial showing how to get a decent looking Clustered and Stacked Column Chart in Excel.

1

Here is a totally different approach.
The screenshot below shows the top of the worksheet with the data in columns A and B and a sequence of charts.
The top left chart is simply an XY Scatter chart.
The top right chart shows the distribution with the X axis scaled as desired.
Error bars have been added to the middle left chart.
The middle right chart ...

1

Dealing with a similar challenge. What you want to do is build a scatter plot instead of a line plot. Scatter easily graphs time series of different frequencies because you can specify different x axis series for different y-axis time series.
In the insert tab insert a scatter plot (probably a straight line plot in your case). Right click on the plot and ...

1

Add a column of zeros to the data.
The first chart below has your original data; the second includes these zeros, which appear along the X axis.
In the third chart I've added data labels below the second series of points (temporarily colored orange to match the series). These show the Y values, all zeros.
In the fourth chart I've formatted the data labels ...

1

To break out your series based on a value in your source (or any other column), you could use helper columns.
Create an additional column for each value you want to break out.
For your Boston column, use the formula =IF([Source] = "Boston", [Parameter 1],na()).
Repeat for each additional source, replacing the comparison value as appropriate.
Define the ...

1

The easiest way is to have each "hair" on your chart be in it's own column.
This is just a simple scatter plot. Make sure that your "Select Data" -->"Hidden and Empty Cells" setting is set to Show empty cells as gaps

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