Timeline for Excel Scatter Chart
Current License: CC BY-SA 4.0
Post Revisions
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 15, 2019 at 10:18 | vote | accept | Naz | ||
| Aug 14, 2019 at 10:10 | answer | added | JvdV | timeline score: 3 | |
| Aug 14, 2019 at 9:42 | comment | added | fixer1234 | Series are in columns, I had to manually reassign ranges in the series definitions to make the values the X axis and the category numbers the Y axis. I would substitute the sector names on the chart. Excel might have a chart type that allows a numeric variable for X and categories for Y. But this got me the basic structure you're looking for. | |
| Aug 14, 2019 at 9:42 | comment | added | fixer1234 | It looks like you've already got the markers. The issue is including the sectors on the Y axis? I think your problem is with how the data is structured. I don't have access to Excel, but I roughed something out in WPS Office, which sucks for charting: i.sstatic.net/vvEua.png. The data is structured with sectors in rows and gender in columns. I picked an XY chart from the limited choices. I had to add numerical values as placeholders for the Y axis. (cont'd) | |
| Aug 14, 2019 at 9:13 | comment | added | Naz | @fixer1234 I thought it would be something easy do to with markers as well, but trying it I kept on getting stuck. I must be missing something. | |
| Aug 14, 2019 at 9:10 | comment | added | fixer1234 | This made me think of another video by the same person as JvdV's link. She has a bunch of videos about creating info charts in Excel using symbols. Your example is much more straightforward than the elaborate stuff she does. I've never tried this, and don't have ready access to Excel, but I think it's just a question of using symbols for the markers instead of dots, and I think it's a built-in feature of recent versions of Excel. | |
| Aug 14, 2019 at 8:57 | history | edited | Naz | CC BY-SA 4.0 |
Additional image added
|
| Aug 14, 2019 at 8:51 | comment | added | JvdV | Maybe this is something you are after? | |
| Aug 14, 2019 at 8:36 | history | asked | Naz | CC BY-SA 4.0 |
