Reputation
4,719
Next tag badge:
140/400 score
96/80 answers
Badges
1 12 32
Newest
 Nice Answer
Impact
~839k people reached

1d
comment How to customise labels on a secondary axis to show student progression as a flight path in Excel?
This should be relatively simple to accomplish. Can you post a screenshot or file to a file sharing site (like dropbox)? Then someone with enough rep can edit into your question.
Aug
29
revised Aligning Stacked Bar Chart w/ Scatter Plot Data
added additional description and images
Aug
29
revised Aligning Stacked Bar Chart w/ Scatter Plot Data
corrected example paragraph and added image and version disclaimer
Aug
28
answered Aligning Stacked Bar Chart w/ Scatter Plot Data
Aug
27
answered How to tell Excel that “Years” are “Years”, not data
Aug
5
comment Excel 2013: stacked bar chart with date, updating date issue
Since the OP is going to update with future events, it would probably be better to set the minimum only, allowing the max to float and include future events.
Aug
5
reviewed Approve altering values in cells
Aug
4
answered Scatterplot of categorical values from pivot table
Aug
1
answered Scatter plot combined with line chart
Jul
23
revised Bar chart displaying too few days
added tag
Jul
23
comment Having trouble graphing big data in Excel (3500+ rows, 2 columns)
If your charting random values against random values, you'll likely get a fairly "boring" chart, with fairly consistent coverage. If you're looking for a pattern, you'll need something that causes the pattern's relationship. So try real data, or use a formula that creates a dependency between the two data sets and see if that gives you what you're looking for.
Jul
23
comment Add multiple series to a dynamic chart
It's true that you'll need a helper column for each unique series you want to create. If you don't need them all, you don't have to create them all. But if you consider what you're trying to accomplish, the only way to chart a series is to have a source for it-so unless you can filter the data before it gets to your table and encode the info from the source, you'll need the additional helper columns to show the data.
Jul
23
answered Add multiple series to a dynamic chart
Jul
21
comment Radar chart in excel - charting with intended “gap data”
Can you explain what a cross-fire axis is? I've never heard the term (related to charts). Also, if you have a sample that you could post in an image/file sharing site and provide a link it would help explain your question.
Jul
21
revised Radar chart in excel - charting with intended “gap data”
language change based upon OP comment
Jul
21
answered how to combine multiple charts with same x-axis (stacking two charts) in Excel
Jul
15
comment how to combine multiple charts with same x-axis (stacking two charts) in Excel
If your data is that varied and you want a single chart, consider a LOG scale for your Y Axis. Rather than having multiple axis, consider using three separate charts in a panel/small multiples configuration to show the data, each to its own scale, but in relation to the other data sets.
Jul
15
comment Linear date axis in pivot tables
Unfortunately, that's correct. However, unless you specifically want a Pivot Chart (and I personally can't think of a good reason to), you can create a standard XY/Scatter Chart from your Pivot Table data-either directly (reference the actual cells of the Pivot) or indirectly (use helper cells to transfer the values to your chart). If you want help with either of those, reword your question to fit, and I'll be happy to help.
Jul
7
comment Linear date axis in pivot tables
Your question is a bit unclear, can you please elaborate-the time is sorted in the same manner as your pivot table (that's built into pivot charts). And it appears that it is chronological (which I assume you also want). However, pivot charts use a line chart type, and that assigns the x-axis values as categorical data, which means the values are handled basically as labels. If you want an appropriate gap between date values (e.g. 3 spaces for 3 days), you'll need to use an XY/Scatter chart, which cannot be done as a Pivot Chart.
Jun
8
revised Excel chart for rail car movements
additional setup info