Graph (100% Stacked Column)

[Liz C]

I have a graph in Excel that I'm trying to reproduce in Access. In Excel,
the chart type is "100% Stacked Column with a 3-D visual effect".

Does anyone have any idea how to create that in Access?

I want to base it on a query that has, for each of 36 months, Paid on time,
Paid 1-5 days late and Paid over 5 days late fields. The way it looks in
Excel, is there is one 3-D bar and most of it it one color, for "paid on
time", there's a little that is another color "paid 1-5 days late", and then
there's a little that is a third color "paid over 5 days late".

Thanks in advance for your help!

 

[Duane Hookom]

This is possible in Access. I just created a 100% Stacked Column 3D chart in
Northwind to display shipper usage by month. The Graph Row Source is:

TRANSFORM Count(Orders.OrderID) AS CountOfOrderID
SELECT Format([OrderDate],"yy mm") AS YrMth
FROM Shippers INNER JOIN Orders ON Shippers.ShipperID = Orders.ShipVia
GROUP BY Format([OrderDate],"yy mm")
PIVOT Shippers.CompanyName;

I double-clicked the graph control in the report design and selected
Chart->Chart Type and selected the Column-100% stacked column with a 3-D
visual effect.

 

[Liz C]

Thanks, Duane. I see the option for that graph now.

If I have four fields - "Period", "OnTime", "OneToFive", "OverFive", how
should the row source read?

Liz

This is possible in Access. I just created a 100% Stacked Column 3D chart in
Northwind to display shipper usage by month. The Graph Row Source is:

TRANSFORM Count(Orders.OrderID) AS CountOfOrderID
SELECT Format([OrderDate],"yy mm") AS YrMth
FROM Shippers INNER JOIN Orders ON Shippers.ShipperID = Orders.ShipVia
GROUP BY Format([OrderDate],"yy mm")
PIVOT Shippers.CompanyName;

I double-clicked the graph control in the report design and selected
Chart->Chart Type and selected the Column-100% stacked column with a 3-D
visual effect.

--
Duane Hookom
Microsoft Access MVP

I have a graph in Excel that I'm trying to reproduce in Access. In Excel,
the chart type is "100% Stacked Column with a 3-D visual effect".

Does anyone have any idea how to create that in Access?

I want to base it on a query that has, for each of 36 months, Paid on time,
Paid 1-5 days late and Paid over 5 days late fields. The way it looks in
Excel, is there is one 3-D bar and most of it it one color, for "paid on
time", there's a little that is another color "paid 1-5 days late", and then
there's a little that is a third color "paid over 5 days late".

Thanks in advance for your help!

 

[Duane Hookom]

Your Row Source would be something like:
SELECT Period, OnTime, OneToFive, OverFive
FROM SomeTableQuery
ORDER BY Period;

--
Duane Hookom
Microsoft Access MVP

Thanks, Duane. I see the option for that graph now.

If I have four fields - "Period", "OnTime", "OneToFive", "OverFive", how
should the row source read?

Liz

This is possible in Access. I just created a 100% Stacked Column 3D chart in
Northwind to display shipper usage by month. The Graph Row Source is:

TRANSFORM Count(Orders.OrderID) AS CountOfOrderID
SELECT Format([OrderDate],"yy mm") AS YrMth
FROM Shippers INNER JOIN Orders ON Shippers.ShipperID = Orders.ShipVia
GROUP BY Format([OrderDate],"yy mm")
PIVOT Shippers.CompanyName;

I double-clicked the graph control in the report design and selected
Chart->Chart Type and selected the Column-100% stacked column with a 3-D
visual effect.

--
Duane Hookom
Microsoft Access MVP

I have a graph in Excel that I'm trying to reproduce in Access. In Excel,
the chart type is "100% Stacked Column with a 3-D visual effect".

Does anyone have any idea how to create that in Access?

I want to base it on a query that has, for each of 36 months, Paid on time,
Paid 1-5 days late and Paid over 5 days late fields. The way it looks in
Excel, is there is one 3-D bar and most of it it one color, for "paid on
time", there's a little that is another color "paid 1-5 days late", and then
there's a little that is a third color "paid over 5 days late".

Thanks in advance for your help!

 

[Liz C]

Never mind, Duane - I figured it out.

Thank you very much for your help!

Liz

 

[GoBrowns!]

I am having a similar issue. I want this kind of graph, but I want it to
count up how many entries were coded with a particular "reason code" for a
given time period. If I could get all the reason codes to show up in one line
as "parts of a whole" that would be perfect.

How would I do this? I am kind of unfamilar with the charts in Access... I
am not really sure where to begin!

This is possible in Access. I just created a 100% Stacked Column 3D chart in
Northwind to display shipper usage by month. The Graph Row Source is:

TRANSFORM Count(Orders.OrderID) AS CountOfOrderID
SELECT Format([OrderDate],"yy mm") AS YrMth
FROM Shippers INNER JOIN Orders ON Shippers.ShipperID = Orders.ShipVia
GROUP BY Format([OrderDate],"yy mm")
PIVOT Shippers.CompanyName;

I double-clicked the graph control in the report design and selected
Chart->Chart Type and selected the Column-100% stacked column with a 3-D
visual effect.

--
Duane Hookom
Microsoft Access MVP

I have a graph in Excel that I'm trying to reproduce in Access. In Excel,
the chart type is "100% Stacked Column with a 3-D visual effect".

Does anyone have any idea how to create that in Access?

I want to base it on a query that has, for each of 36 months, Paid on time,
Paid 1-5 days late and Paid over 5 days late fields. The way it looks in
Excel, is there is one 3-D bar and most of it it one color, for "paid on
time", there's a little that is another color "paid 1-5 days late", and then
there's a little that is a third color "paid over 5 days late".

Thanks in advance for your help!

 

[Duane Hookom]

Do you have a query that returns the values needed in your chart? If so, use
this as the Row Source of your graph/chart control. Just play with its design
once you have this set.
--
Duane Hookom
Microsoft Access MVP

I am having a similar issue. I want this kind of graph, but I want it to
count up how many entries were coded with a particular "reason code" for a
given time period. If I could get all the reason codes to show up in one line
as "parts of a whole" that would be perfect.

How would I do this? I am kind of unfamilar with the charts in Access... I
am not really sure where to begin!

This is possible in Access. I just created a 100% Stacked Column 3D chart in
Northwind to display shipper usage by month. The Graph Row Source is:

TRANSFORM Count(Orders.OrderID) AS CountOfOrderID
SELECT Format([OrderDate],"yy mm") AS YrMth
FROM Shippers INNER JOIN Orders ON Shippers.ShipperID = Orders.ShipVia
GROUP BY Format([OrderDate],"yy mm")
PIVOT Shippers.CompanyName;

I double-clicked the graph control in the report design and selected
Chart->Chart Type and selected the Column-100% stacked column with a 3-D
visual effect.

--
Duane Hookom
Microsoft Access MVP

I have a graph in Excel that I'm trying to reproduce in Access. In Excel,
the chart type is "100% Stacked Column with a 3-D visual effect".

Does anyone have any idea how to create that in Access?

I want to base it on a query that has, for each of 36 months, Paid on time,
Paid 1-5 days late and Paid over 5 days late fields. The way it looks in
Excel, is there is one 3-D bar and most of it it one color, for "paid on
time", there's a little that is another color "paid 1-5 days late", and then
there's a little that is a third color "paid over 5 days late".

Thanks in advance for your help!