New answers tagged charts
1
vote
How do I change the vertical axis on an Excel graph to display significant time periods? The gridlines are set at odd times
To change the vertical axis on an Excel graph to display significant time periods within a 24-hour period, you can follow these steps:
Right-click on the vertical axis and select "Format Axis&...
- 387
0
votes
Excel: How to select a chart's data range using a corresponding value in another cell?
I am not clear on this. Posting a file may help more.
I am guessing that the names in the SummarySheet are the column header's names, right?
So then these would be used to select the second row ...
- 19
1
vote
Accepted
How do I indicate nested data groups side-by-side in an Excel stacked column chart?
To achieve your desired result you need to slightly restructure your data as below. The empty line is not necessary but leads to a better visualisation. Using this data structure, you will be able to ...
- 1,000
0
votes
Excel: making a chart with non-evenly spaced years on the x-axis
Another options is to use scatter graph with line.
Organize Your Data: Ensure your data is organized in two columns, one for Year and one for Quantity.
Insert a Scatter Plot:
Highlight the data ...
0
votes
How to create a single stacked bar chart with dual y axes in excel?
I assume this is what you want:
As you can see you need to restructure your input data range.
Also look at :
Where series1 Looks like :
And as you already figered out:
- 101
1
vote
Can you combine stacked and clustered columns in an excel chart?
AFAIK it is impossible to achieve such an effect in a simple way. It can only be achieved by indirectly combining and overlaying data. The main and the secondary axes should be used.
From the data ...
- 2,310
0
votes
Can you combine stacked and clustered columns in an excel chart?
This is the best I could do, but it's not in bars. I'm not sure it's possible to put stacked bars next to a regular one.
- 176
Top 50 recent answers are included