xcellerator
New Member
- Joined
- Feb 22, 2017
- Messages
- 23
- Office Version
- 2019
- Platform
- MacOS
Late at night and I'm at a total loss...failing on multiple fronts: both how to create the x-axis (which should be fiscal year and quarters, and then how to create the scatters for the 2 different groups (say Group A in blue dots, Group B in red)! I get the FY-FQ axis looking like numbers (0, 10, ...), and then I can't figure out how to separate the 2 groups into different colors.
Thank you for the help on what is probably a basic question!!
Example set:
<style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl63 { }</style>
<tbody>
</tbody>
Thank you for the help on what is probably a basic question!!
Example set:
<style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl63 { }</style>
FY - FQ | Group | Price |
2015 - Q1 | Group A | 3 |
2015 - Q2 | Group A | 4 |
2015 - Q3 | Group A | 2 |
2015 - Q3 | Group A | 6 |
2015 - Q3 | Group A | 5 |
2015 - Q4 | Group A | 1 |
2015 - Q4 | Group A | 5 |
2015 - Q4 | Group A | 4 |
2016 - Q2 | Group A | 8 |
2016 - Q2 | Group A | 6 |
2016 - Q3 | Group A | 5 |
2016 - Q3 | Group A | 4 |
2016 - Q3 | Group A | 2 |
2016 - Q4 | Group A | 9 |
2016 - Q4 | Group A | 7 |
2016 - Q4 | Group A | 5 |
2015 - Q2 | Group B | 6 |
2015 - Q2 | Group B | 4 |
2015 - Q3 | Group B | 6 |
2015 - Q3 | Group B | 3 |
2015 - Q4 | Group B | 4 |
2015 - Q4 | Group B | 2 |
2015 - Q4 | Group B | 8 |
2015 - Q4 | Group B | 4 |
2016 - Q1 | Group B | 5 |
2016 - Q1 | Group B | 5 |
2016 - Q1 | Group B | 6 |
2016 - Q2 | Group B | 7 |
2016 - Q2 | Group B | 4 |
2016 - Q3 | Group B | 6 |
2016 - Q3 | Group B | 5 |
2016 - Q4 | Group B | 2 |
<tbody>
</tbody>