Charting different data formats in the same chart

[MILO]

Not sure if this is possible or not. I’ve got a sheet with three columns

A=total number of items
B=is the percentage of each row to the grand total of items in column A
C=is a dollar amount.

I’m trying to create a bar graph that reflects all three columns. Can this
be done or do I need to make three separate charts and if that’s the case is
it possible to combine bar charts?

 

[Rita Brasher]

Milo,
Whenever I've had to do this type of graph, I would do the total as a
column graph using the left axis, the dollar amount as a line using the
right axis, then I'd use the x-y labeler (see link below) and place the
percentage as a label above the column. Just my idea...

Link to X-Y Labeler Application:
http://www.appspro.com/Downloads/XYChartLabeler.exe

Good luck!
Rita

 

[MILO]

Good stuff thank you very much

Milo,
Whenever I've had to do this type of graph, I would do the total as a
column graph using the left axis, the dollar amount as a line using the
right axis, then I'd use the x-y labeler (see link below) and place the
percentage as a label above the column. Just my idea...

Link to X-Y Labeler Application:
http://www.appspro.com/Downloads/XYChartLabeler.exe

Good luck!
Rita