Hello All:
I couldn't find a way to solve this using normal forms so was wondering if there was some VBA coding that might do it.
Using the pivot table/chart wizard I created a Pivot Table that looks like
Project1 Project2
January
Februrary 1 5
March
April 4 7
I also have a bar-chart associated with the above (Jan-Feb-Mar-Apr on the x-axis, Count on the Y-axis). Each column bar is divided into segments by the project. I want to display the values i.e. 1, 4 along with the Legend Keys.
See EXAMPLE Below:
See below for the month of Februrary:
------
| 5 |
| |
------
| 1 |
| |
------
Jan Feb Mar Apr ......
Right Now the Legend is displayed as below (color coding not shown
)
Project1 Project 2
WHAT I WANT is that Legend displayed as:
Project1-5 Project 2-1
Thank you
RiderJon
"I might have created ctrl+alt+del,
But Bill made it famous" - Dr. Dave
I couldn't find a way to solve this using normal forms so was wondering if there was some VBA coding that might do it.
Using the pivot table/chart wizard I created a Pivot Table that looks like
Project1 Project2
January
Februrary 1 5
March
April 4 7
I also have a bar-chart associated with the above (Jan-Feb-Mar-Apr on the x-axis, Count on the Y-axis). Each column bar is divided into segments by the project. I want to display the values i.e. 1, 4 along with the Legend Keys.
See EXAMPLE Below:
See below for the month of Februrary:
------
| 5 |
| |
------
| 1 |
| |
------
Jan Feb Mar Apr ......
Right Now the Legend is displayed as below (color coding not shown
)Project1 Project 2
WHAT I WANT is that Legend displayed as:
Project1-5 Project 2-1
Thank you
RiderJon
"I might have created ctrl+alt+del,
But Bill made it famous" - Dr. Dave
