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> [TABLE="width: 195"]
<tbody>[TR]
[TD="width: 65"]FY - FQ[/TD]
[TD="width: 65"]Group[/TD]
[TD="width: 65"]Price[/TD]
[/TR]
[TR]
[TD="class: xl63"]2015 - Q1[/TD]
[TD]Group A[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]2015 - Q2[/TD]
[TD]Group A[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]2015 - Q3[/TD]
[TD]Group A[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]2015 - Q3[/TD]
[TD]Group A[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]2015 - Q3[/TD]
[TD]Group A[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]2015 - Q4[/TD]
[TD]Group A[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]2015 - Q4[/TD]
[TD]Group A[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]2015 - Q4[/TD]
[TD]Group A[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]2016 - Q2[/TD]
[TD]Group A[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]2016 - Q2[/TD]
[TD]Group A[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]2016 - Q3[/TD]
[TD]Group A[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]2016 - Q3[/TD]
[TD]Group A[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]2016 - Q3[/TD]
[TD]Group A[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]2016 - Q4[/TD]
[TD]Group A[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]2016 - Q4[/TD]
[TD]Group A[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]2016 - Q4[/TD]
[TD]Group A[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]2015 - Q2[/TD]
[TD]Group B[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]2015 - Q2[/TD]
[TD]Group B[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]2015 - Q3[/TD]
[TD]Group B[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]2015 - Q3[/TD]
[TD]Group B[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]2015 - Q4[/TD]
[TD]Group B[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]2015 - Q4[/TD]
[TD]Group B[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]2015 - Q4[/TD]
[TD]Group B[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]2015 - Q4[/TD]
[TD]Group B[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]2016 - Q1[/TD]
[TD]Group B[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]2016 - Q1[/TD]
[TD]Group B[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]2016 - Q1[/TD]
[TD]Group B[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]2016 - Q2[/TD]
[TD]Group B[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]2016 - Q2[/TD]
[TD]Group B[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]2016 - Q3[/TD]
[TD]Group B[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]2016 - Q3[/TD]
[TD]Group B[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]2016 - Q4[/TD]
[TD]Group B[/TD]
[TD="align: right"]2[/TD]
[/TR]
</tbody>[/TABLE]
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> [TABLE="width: 195"]
<tbody>[TR]
[TD="width: 65"]FY - FQ[/TD]
[TD="width: 65"]Group[/TD]
[TD="width: 65"]Price[/TD]
[/TR]
[TR]
[TD="class: xl63"]2015 - Q1[/TD]
[TD]Group A[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]2015 - Q2[/TD]
[TD]Group A[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]2015 - Q3[/TD]
[TD]Group A[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]2015 - Q3[/TD]
[TD]Group A[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]2015 - Q3[/TD]
[TD]Group A[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]2015 - Q4[/TD]
[TD]Group A[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]2015 - Q4[/TD]
[TD]Group A[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]2015 - Q4[/TD]
[TD]Group A[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]2016 - Q2[/TD]
[TD]Group A[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]2016 - Q2[/TD]
[TD]Group A[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]2016 - Q3[/TD]
[TD]Group A[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]2016 - Q3[/TD]
[TD]Group A[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]2016 - Q3[/TD]
[TD]Group A[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]2016 - Q4[/TD]
[TD]Group A[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]2016 - Q4[/TD]
[TD]Group A[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]2016 - Q4[/TD]
[TD]Group A[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]2015 - Q2[/TD]
[TD]Group B[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]2015 - Q2[/TD]
[TD]Group B[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]2015 - Q3[/TD]
[TD]Group B[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]2015 - Q3[/TD]
[TD]Group B[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]2015 - Q4[/TD]
[TD]Group B[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]2015 - Q4[/TD]
[TD]Group B[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]2015 - Q4[/TD]
[TD]Group B[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]2015 - Q4[/TD]
[TD]Group B[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]2016 - Q1[/TD]
[TD]Group B[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]2016 - Q1[/TD]
[TD]Group B[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]2016 - Q1[/TD]
[TD]Group B[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]2016 - Q2[/TD]
[TD]Group B[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]2016 - Q2[/TD]
[TD]Group B[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]2016 - Q3[/TD]
[TD]Group B[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]2016 - Q3[/TD]
[TD]Group B[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]2016 - Q4[/TD]
[TD]Group B[/TD]
[TD="align: right"]2[/TD]
[/TR]
</tbody>[/TABLE]