Hi,
I am trying to reformat a report by using pivot table. I need to pull images into the pivot table but cant do so. These images correlate to the item# in the first row. is there a way to get this done whether its assigning a value to the image or some other way? if you take a look at the excel sheet, the first sheet is the report and second sheet is the pivot table.
thanks for your appreciated help.
Maurice
Copy of ItemStatusAvailable.xls
Hi Maurice and welcome to the forum,
I don't believe there is a way to put the images INTO the Pivot itself. I'd suggest you start looking to use a 3rd sheet and grab info from the Pivot and images from your first sheet to build a 3rd sheet that shows what you want.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thanks for your response. if i were to copy and past my pivot table into a 3rd sheet, how would i go about grabbing the images?
The Pictures aren't really stuck with a row. They are simply put on your first sheet. I'm working on this...
How about a Hyperlink to the pictures? I need to study more.
Maybe one of the smart gurus has run into this before.
As far as I know there are no hyperlinks. This is a system made report. Let me know if there is any other info I could get you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks